View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Jorge Cervantes Jorge Cervantes is offline
external usenet poster
 
Posts: 21
Default function for date?

Thanks Rick.

Jorge


"Rick Rothstein (MVP - VB)" wrote in
message ...
Is this what you are looking for?

For today: =TEXT(TODAY(),"mmmm dd, yyyy")

Specified date: =TEXT(DATE(2007,11,25),"mmmm dd, yyyy")

Rick


"Jorge Cervantes" wrote in message
...
You are correct though, but that is not what I asked for.
When I tried both functions, it shows 11/26/07.

I need a date function for "November 26, 2007".

Jorge




"Niek Otten" wrote in message
...
=today()

Or, on any other day:

=DATE(2007,11,25)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jorge Cervantes" wrote in message
...
| What is the date function for November 25th, 2007 for Excel? TIA.
| Jorge
|
|