function for date?

[Jorge Cervantes]

What is the date function for November 25th, 2007 for Excel? TIA.
Jorge

 

[Niek Otten]

=today()

Or, on any other day:

=DATE(2007,11,25)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| What is the date function for November 25th, 2007 for Excel? TIA.
| Jorge
|
|

 

[Jorge Cervantes]

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

 

[Rick Rothstein \(MVP - VB\)]

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]

Thanks Rick.

Jorge

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

 

[JMB]

Change the cell format
Format/Cells/Custom
mmmm d, yyyy

 

[Jorge Cervantes]

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

 

[Peo Sjoblom]

It's no difference, the date functions haven't changed. What happened when
you tried it on excel 97?
Regardless you don't need the text function or the date function to get a
date to display as

November 26, 2007

just type in the date as 11/26/07 and the do format>cells>number>custom and
use

mmmm dd, yyyy


--


Regards,


Peo Sjoblom

 

[Jorge Cervantes]

I am not that computer-literate.

When I type in "=TEXT(TODAY(),"mmmm dd, yyyy")" in a cell of 97Excel xls,
it did convert into date.
It shows the same "=TEXT(TODAY(),"mmmm dd, yyyy")" function in the cell.
All templates from 97Excel did not work.

But when I type it in 2003 Excel sheet, it automatically convert into
November 28, 2007.

just type in the date as 11/26/07 and the do format>cells>number>custom
and use

I could not quite follow your instruction. I got stuck at "number".

Jorge,

 

[Peo Sjoblom]

Type 11/26/07 in a cell, select the cell, press Ctrl and 1
then scroll down to custom and type in mmmm dd, yyyy in the type box on the
right hand side then press enter


--


Regards,


Peo Sjoblom

 

[Jorge Cervantes]

type in mmmm dd, yyyy in the type box on the right hand side then press

enter

When I follow your instruciton, here is a problem.
There is no column or anything to TYPE IN.
I got to select one from the existing codes.
Closest one I could see from the drop down codes is m/d/yyy.
Is that what you meant?
Jorge

 

[Peo Sjoblom]

No, you have to physically highlight whatever is in the right hand side just
below
Type:
before you can type in the format

If you just go to an empty new cell it will say General in the little box
below the word Type: Now select that word with your mouse and type in the
new format


In the left pane it says Category:, then beneath you can see all different
categories, the bottom one says Custom, select custom and you will get the
Type: box in the right pane



--


Regards,


Peo Sjoblom

 

[Jorge Cervantes]

Thanks Peo,

I have never done similar thing before. Now, I am learning how.
Now, I typed in the type box ant then hit enter.

Then, how to use it?

Jorge

 

[Peo Sjoblom]

Put 11/26/07 in a cell where you have applied this formatting

mmmm dd, yyyy


and it will show as

November 26, 2007



--


Regards,


Peo Sjoblom

 

[Jorge Cervantes]

Thank you.

I got it.

Jorge

Put 11/26/07 in a cell where you have applied this formatting

mmmm dd, yyyy


and it will show as

November 26, 2007



--


Regards,


Peo Sjoblom

 

[Jorge Cervantes]

Rick,

Could you please come up with a similar function for 97Excel?
I am waiting. Jorge

 

[Peo Sjoblom]

It's not a function and it works in Excel 97


--


Regards,


Peo Sjoblom

 

[Sandy Mann]

Hi Peo,

Being as Jorge was replying to Rick and the only post from Rick that I can
see in this thread is:

*****************************************
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
*********************************************

I am wondering if my OE is missing posts again becuase that formula works in
XL97

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Peo Sjoblom]

While he might be replying back to Rick he quotes JMB so he might have
thought that JMB was Rich? Nevertheless there is no need for any functions
and also if he wants to use the TEXT function

=TEXT("11/26,07","mmmm dd, yyyy")


will suffice.



--


Regards,


Peo Sjoblom

 

[Jorge Cervantes]

OK.
Now I realized that there was a confusion somewhere.
Since my wife computer is installed with 97office suite, I checked how those
functions work on 97Excel.

With native 97Excel or 2003Excel files, "=TEXT(DATE(2007,11,25),"mmmm dd,
yyyy")" function worked just fine.
No problem.

But the above function did not work on any of 97Excel files which are
opened under 2003Excel.

(Note: my computer is installed with 2003 Office Suite. But I use 97Excel
templates under 2003 Excel.).

I hope that this clarifies what was the problem.

Jorge