| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Today() ... Month() ... Formatt mmm
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Today() ... Month() ... Formatt mmm
3 is third day from the start of excel's calendar (usually Dec 31, 1899 for
windows users)--so it's jan 3, 1900. If you did =b2 and formatted as mmm you'd be set. 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Today() ... Month() ... Formatt mmm
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Today() ... Month() ... Formatt mmm
Ken,
i think that the function like month() or year() converts the date value in an integer value...hence if you need to show different date format while retaining the real date value, better stick with the date value and play with the formatcellnumbersdate ...so you dont loose the logical conversion. regards -- ***** birds of the same feather flock together.. "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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| THe Last DATE of the previous month from today | Excel Worksheet Functions | |||
| THe Last DATE of the previous month from today | Excel Worksheet Functions | |||
| Days in a month as of today | Excel Worksheet Functions | |||
| conditional format for if month(today) = xxx | Excel Worksheet Functions | |||
| Conditional Format (month and year) = Today() | Excel Worksheet Functions | |||
Linear Mode
