Date Function
 

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?

Date Function
 

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
???



Amy wrote:

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?

--

Dave Peterson