 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008Where am I going wrong? - Date type function.
Hi, I'm trying to generate the following title: "Wealth Management - March (current month) 2008(current year)" I'm using the following formula: ="Wealth Management - "&TEXT(MONTH(TODAY()),"mmmm")&" "&YEAR(TODAY()) The year bit works, returning 2008. The month just won't work - it keeps returning January and I can't figure out why. Where am I going wrong? Cheers! ="Wealth Management - "&TEXT(TODAY(),"mmmm yyyy") XL stores dates as numbers. Month(Today()) returns 3, which is interpreted as 1/3/1900 (and is why you keep getting January). > Hi, > [quoted text clipped - 13 lines] > > Cheers! Unless your options are set up to use the 1904 date system, then 3 would be 1/3/1904. > ="Wealth Management - "&TEXT(TODAY(),"mmmm yyyy") > [quoted text clipped - 18 lines] > > > > Cheers! Sorry - missed it! Thanks so much. Tom. > Unless your options are set up to use the 1904 date system, then 3 would be > 1/3/1904. [quoted text clipped - 21 lines] > > > > > > Cheers! quite alright - thanks for the feedback. > Sorry - missed it! > [quoted text clipped - 27 lines] > > > > > > > > Cheers! So what's a good solution? Cheers. > ="Wealth Management - "&TEXT(TODAY(),"mmmm yyyy") > [quoted text clipped - 18 lines] > > > > Cheers! I included a solution in the first line of my post - please re-read. > So what's a good solution? > [quoted text clipped - 22 lines] > > > > > > Cheers! It's because MONTH(TODAY()) returns 3. That is the dateserial number of day 3 which is January 3, 1900. So "mmmm:" returns January. What you need is ="Wealth Management - "&TEXT(TODAY(),"mmmm")&" "&YEAR(TODAY()) or ="Wealth Management - "&TEXT(TODAY(),"mmmm")&" "&TEXT(TODAY(),"yyyy") That will give you Wealth Management - March 2008. Tyro > Hi, > [quoted text clipped - 13 lines] > > Cheers! Or you can use JMB's answer which is superior to mine Tyro > It's because MONTH(TODAY()) returns 3. That is the dateserial number of > day 3 which is January 3, 1900. So "mmmm:" returns January. [quoted text clipped - 23 lines] >> >> Cheers! only because my first post didn't go through, giving me an opportunity to tweak the formula before posting my *final* answer <g> > Or you can use JMB's answer which is superior to mine > [quoted text clipped - 27 lines] > >> > >> Cheers! Actually, I really don't have a lot of time to play with this stuff. I've been in the computer field since September 1964. I don't try anymore to produce the best answer, just an answer. Perhaps when I retire in 6 years at age 70, I may play with formulas to the extent that they become obfuscated. But in the meantime, JMB, continue to contribute. It is very important. Tyro > only because my first post didn't go through, giving me an opportunity to > tweak the formula before posting my *final* answer <g> [quoted text clipped - 31 lines] >> >> >> >> Cheers! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.