Date Function

A

Amy

Is there a function that returns the month and day when you type in one of
the numbers 1-365?
If not, does anyone know the formula that will return the month and day?
 
D

Dave Peterson

maybe (with 1-365 typed into A1):

If you want the date:
=DATE(YEAR(TODAY()),1,A1)

if you want the month:
=month(DATE(YEAR(TODAY()),1,A1))

if you want the day:
=day(DATE(YEAR(TODAY()),1,A1))

or
=DATE(YEAR(TODAY()),1,A1)
formatted as:
mmdd
???
 
Top