I have a performance spreadsheet (shows how we have performed over a time span) that updates based on the date. The issue is when the date/time changes within Excel. Example of the issue: The sheet is printed at 05:19 and the data is 11/14/12; then when the same sheet is printed out at 06:19, the data is for 11/15/12. Can anyone tell me when Excel calculates a date change? And how can I make it an earlier date/time change? Our reports usually run around 05:00 to prepare for the next shift coming in at 06:00.
Bookmarks