Forum Discussion
sabriakter
Jan 28, 2021Copper Contributor
Can someone explain the meaning of this formula?
=IF($B$11>DATE(103,1,1),IF($B$11<DATE(103,12,31),MAX(DATE(103,1,1),$B$11),""),IF($B$11<DATE(103,1,1),DATE(103,1,1),""))
JMB17
Jan 28, 2021Bronze Contributor
Excel's dates are integers that starting from a base date, which is typically 1/1/1900, but there is an option to use 1/1/1904. So, 103 years from the presumed base year of 1900 would be 2003 (unless you are using 1904 base year, you could enter =Date(103,1,1) in cell and see what it returns).