gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 351
- Office Version
- 365
- Platform
- Windows
- Mobile
I have a bunch of code dependent on the user's chosen date. So it's frustrating that I'm getting two different values as to what the supposed weekday falling on April 8th, 2023 is (arbitrary date). In the picture below on the left is what Excel thinks the day will be, and on the right is my system clock's answer. Why are they out of sync? I looked at this for a while to make sure I wasn't seeing things, but maybe I'm missing something obvious. I took a second screenshot of the Excel date formatted as a weekday. However, in a different workbook it shows the real day is Saturday, so something in this workbook is acting up.