This works great for today's date- actually I didn't explain quite right- can
I format so that whatever date I enter in the cell will show the month in all
caps?

thanks again~

"Gary''s Student" wrote:

=UPPER(TEXT(TODAY(),"mmmm dd, yyy"))
--
Gary's Student


"lamersn" wrote:

So it would be MARCH 16, 2007, for example?

thanks!