Hi,
=TEXT(DATE(2007,11,25),"mmmm dd, yyyy")
The above format works perfect on 2003Excel (from 2003 Office Suite) but did
not work on 97Excel file (from 97Office Suite).
Although I am using 2003Excel, I still use some excel templates from 97
Excel.
I would very much appreciate it if you could post the date function for 97
Excel.
Thank you. 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
|
|