Date and Day in Excel

[Guest]

I have 12 Sheets, each representing each month of the year...Jan, feb......Dec.
I need Date and Day in 1st and 2nd colum of each sheet representing that
month.
Need to know how to formulate this...Thanks in advance for any help..

 

[Frank Kabel]

Hi
try the following formula to get the first day of the current year for
this montn:
=DATEVALUE("1-" &
RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("filename",A1),1)) & "-" & TEXT(TODAY(),"YYYY")

If you put this in cell A1 you could use the following formula in B1 to
get only the day:
=A1
and format this cell with the custom format
"DDD"

 

[Guest]

Thank You so much for your help.....

Hi
try the following formula to get the first day of the current year for
this montn:
=DATEVALUE("1-" &
RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND
("]",CELL("filename",A1),1)) & "-" & TEXT(TODAY(),"YYYY")

If you put this in cell A1 you could use the following formula in B1 to
get only the day:
=A1
and format this cell with the custom format
"DDD"

--
Regards
Frank Kabel
Frankfurt, Germany

I have 12 Sheets, each representing each month of the year...Jan, feb......Dec.
I need Date and Day in 1st and 2nd colum of each sheet representing that
month.
Need to know how to formulate this...Thanks in advance for any help..