Forum Discussion
abegum
6 years agoFrequent Visitor
DATES
Hi i want to know why the format of my date looks like sum,
saglamtimur
6 years agoResolver II
Because it is simply, math
For year 1899
1899 - 2020 = -121
121 * 12 = -1452
for MONTH(TODAY())=7
1 - 7 = -6
Finally
-1452 + (-6)= -1458
What else do you expect?
If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍