Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-30-2021, 06:17 PM
Marcia's Avatar
Marcia Marcia is offline Today is Monday but the SaveDate returned Sunday Windows 10 Today is Monday but the SaveDate returned Sunday Office 2019
Expert
Today is Monday but the SaveDate returned Sunday
 
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Today is Monday but the SaveDate returned Sunday

Hi. It is Monday May 31, 2021 here in my country. Our office issues certifications so I tried saving the date of issuance through the SaveDate. My problem is that it returns Sunday May 30, 2021 instead of Monday May 31, 2021.
I checked the Regional settings and it was correctly set to (English) Philippines. Any suggestion to correct the wrong date? I tested it in Excel using Ctrl+Semi-Colon and the correct date, May 31, 2021 showed.
Thank you.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word set an offset to SAVEDATE rogerbowering Word 1 06-18-2019 06:17 AM
Today is Monday but the SaveDate returned Sunday Subtracting Hours from SaveDate rogerbowering Word 3 06-18-2019 06:16 AM
Today is Monday but the SaveDate returned Sunday Fifteen Days From Today's Date, (Not Counting Saturday & Sunday). StephenRay Word VBA 13 07-26-2017 11:22 AM
different rates on sunday pascalbidouille Project 1 07-01-2015 01:58 PM
Today is Monday but the SaveDate returned Sunday force task start on monday pascalbidouille Project 2 07-01-2015 01:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft