Thread
:
Date Formulas
View Single Post
#
3
Harald Staff
Posts: n/a
Hi
With the date of your birth in cell A1, this formula in another cell will
return this year's birthday:
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))
HTH. best wishes Harald
"Charlene" skrev i melding
...
How can I make a cell correct the year of a date
Reply With Quote