using date function, month shows as January when i type (12)

H

hsas

when date of birth is A1 and i use the formula
=date(year(A1)+19,month(12),day(31)), to get the last day of the year before
the 20th birthday, 31/1/1919 appears instead of 31/12/1919. why is this? if
i take the +19 away, the same thing happens. The only time it works is if i
specify the year instead of using another cell.
 
D

Dave O

The reason your original formula did not work is because the MONTH()
and DAY() functions require serial date numbers (that is to say, an
Excel date equivalent expressed as a number).
 
Top