Forum Discussion
CURRENT DATE KEEPS REVERTING BACK TO 13/01/2000
H again,
For some reason the dates in the rest of the column keep reverting back to an older date when data is entered. This is my formula - =IF(Q17<>"",IF(S17="",NOW(),Q17),"")
6 Replies
Ding080 I suspect that in such cases the formula is returning the value from column Q17 and not the value for NOW().
If the value in Q17, for example, equals 13.333333 you formula will return the 13th of January 1900, 8:00 as 13.33333 is the date/time representation for the 13th day as from January 1, 1900 (the start of the Excel calendar). The time comes from the decimals meaning that we are one-third into the day, i.e. 8AM (0.0333333 X 24)
- oh ok, is there a way to prevent this from happening? If i enter a new row of data and the date cell gets filled automatically it changes all the surrounding dates back to 13/01/00
Ding080 Sorry, don't follow ".....it changes all the surrounding dates back to 13/01/00"
Can you share a file (via Onedrive or similar) or at least provide a screenshot that shows a more complete picture? I.e. not just a few cells, one of which has 13/01/00. What's in columns Q and S, for instance?
