Posted to microsoft.public.excel.misc

Ken

external usenet poster

Posts: 590

Today() ... Month() ... Formatt mmm

Thanks all ... C2 is now B2 ... :)

Thanks ... Kha

"Gary''s Student" wrote:

Too complicated. Make C2:
=B2

remember that
3
is actually
Tuesday, January 03, 1900

--
Gary''s Student
gsnu200708

"Ken" wrote:

Excel2003 ...

Cell B2 formula ... =Today() ... return = 03/02/07
Cell C2 formula ... =Month(B2) ... return = 3

So far so good ...

Issue is ... when I format Cell C2 to ... custom "mmm" ... anticipating
return = "Mar" ... I get a return = "Jan".

What am I missing? ... Thanks ... Kha

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
THe Last DATE of the previous month from today	CmK	Excel Worksheet Functions	6	May 4th 07 03:20 PM
THe Last DATE of the previous month from today	Mike	Excel Worksheet Functions	0	February 28th 07 01:59 PM
Days in a month as of today	Daniel Q.	Excel Worksheet Functions	2	January 25th 07 07:15 PM
conditional format for if month(today) = xxx	Todd	Excel Worksheet Functions	3	January 24th 07 12:16 AM
Conditional Format (month and year) = Today()	Scott	Excel Worksheet Functions	3	November 4th 05 04:52 PM

All times are GMT +1. The time now is 04:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us