Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating current month
I need a worksheet to calculate the current month and print it out in text
form example September and not in numeric form example 9. I have tried playing around with the date functions but have not come up with the solution. Can anyone suggest a method for accomplishing this taskÉ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating current month
=TEXT(TODAY(),"mmm")
-- Kind regards, Niek Otten Microsoft MVP - Excel "Randy" wrote in message ... I need a worksheet to calculate the current month and print it out in text form example September and not in numeric form example 9. I have tried playing around with the date functions but have not come up with the solution. Can anyone suggest a method for accomplishing this taskÉ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating current month
To Niek: Since the OP's example indicated he wanted the full month name
spelled out, your formula needs another 'm' in the format pattern... =TEXT(TODAY(),"mmmm") To Randy: You can also just put =TODAY() in a cell and Custom Format the cell using mmmm as the Type. -- Rick (MVP - Excel) "Niek Otten" wrote in message ... =TEXT(TODAY(),"mmm") -- Kind regards, Niek Otten Microsoft MVP - Excel "Randy" wrote in message ... I need a worksheet to calculate the current month and print it out in text form example September and not in numeric form example 9. I have tried playing around with the date functions but have not come up with the solution. Can anyone suggest a method for accomplishing this taskÉ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating current month
Hi,
Enter =TODAY() or NOW() in a cell and then choose Format, Cells, Number tab, Custom and on the Type line on the right enter MMMM or mmmm. -- Thanks, Shane Devenshire "Randy" wrote: I need a worksheet to calculate the current month and print it out in text form example September and not in numeric form example 9. I have tried playing around with the date functions but have not come up with the solution. Can anyone suggest a method for accomplishing this taskÉ |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating current month
Thanks Rick!
-- Kind regards, Niek Otten Microsoft MVP - Excel "Rick Rothstein" wrote in message ... To Niek: Since the OP's example indicated he wanted the full month name spelled out, your formula needs another 'm' in the format pattern... =TEXT(TODAY(),"mmmm") To Randy: You can also just put =TODAY() in a cell and Custom Format the cell using mmmm as the Type. -- Rick (MVP - Excel) "Niek Otten" wrote in message ... =TEXT(TODAY(),"mmm") -- Kind regards, Niek Otten Microsoft MVP - Excel "Randy" wrote in message ... I need a worksheet to calculate the current month and print it out in text form example September and not in numeric form example 9. I have tried playing around with the date functions but have not come up with the solution. Can anyone suggest a method for accomplishing this taskÉ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
Calculate the first day of the month for the current month? | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Current Month | Excel Worksheet Functions |