| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Where 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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #VALUE! error - Occurs when the wrong type of argument or operand | Excel Discussion (Misc queries) | |||
| how to convert date type to text type | Excel Discussion (Misc queries) | |||
| VBA setting formula for a cell causes "Wrong data type" error | Excel Discussion (Misc queries) | |||
| date entered wrong or not as a date | Excel Worksheet Functions | |||
| using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) | |||
Threaded Mode
