close
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?
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:
gt;
gt; Is there a function that returns the month and day when you type in one of
gt; the numbers 1-365?
gt; If not, does anyone know the formula that will return the month and day?
--
Dave Peterson
全站熱搜
留言列表
