Dates

[rbahbah]

Hi all,

For any given month, say February for example, I'd like excel to list

Wednesday February 01, 2009
Thursday February 02, 2009
etc.

If I change February to March, excel should automatically list the days in March.

Anyone?

 

[Diablo II]

edit cell formatting go to custom, type in dddd mmmm dd, yyyy

 

[rbahbah]

But still, that would require the person to type in "02/01/2009" and I just want them to use "February" instead of typing the actual date.

 

[Diablo II]

you may be abel to do this with VBA, i dont think you can do this with formulas, but i dont know, im better with VBA, then formulas, but i do know that you can not do it with a formula in the same cell, you can all so have them just type =now() for todays date. in a cell.

 

[barry houdini]

Lets assume that the month as Text will be put in A1, either in long or short form, e.g. "March" or "Mar"

Put this formula in A2 copied down to A32

=IF(A1="","",IF(ISERR((ROWS(A$2:A2)&A$1)+0),"",TEXT((ROWS(A$2:A2)&A$1)+0,"dddd mmmm dd, yyyy")))

Year will always be the current year......