In a little sheet I have stats that update ages and anniversaries. One of the ages was supposed to turn over today, but it didn't.
If I change the year to 1967, the age reads correctly. I have tried multiple past decades. Some turn over as expected, and others do not. 1907 works. 1917 doesn't. 2017 doesn't work. 2007 does.
If I change the date to 1/17/57 it will show a correct age for the year. So maybe tomorrow the age will be correct. But it really should change today, right?
I have tried changing the date format but it doesn't seem to make a difference. Could someone please help with this or help me understand why it's doing this? Maybe it's just a glitch in Excel. Thank you so much.
If I change the year to 1967, the age reads correctly. I have tried multiple past decades. Some turn over as expected, and others do not. 1907 works. 1917 doesn't. 2017 doesn't work. 2007 does.
If I change the date to 1/17/57 it will show a correct age for the year. So maybe tomorrow the age will be correct. But it really should change today, right?
I have tried changing the date format but it doesn't seem to make a difference. Could someone please help with this or help me understand why it's doing this? Maybe it's just a glitch in Excel. Thank you so much.