Thread: [Solved] Today is Monday but the SaveDate returned Sunday
View Single Post
 
Old 05-30-2021, 06:17 PM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
  
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