Date and Day in Excel

R

RizMomin

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..
 
F

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"
 
R

RizMomin

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

Frank Kabel said:
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

RizMomin said:
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..
Click to expand...
Click to expand...
 
Top