=MONTH FORMULA

Deano

Active Member
Joined
May 2, 2004
Messages
264
Hi

If I use the formul =month(today()), I get a result of 11.

Can I modify this formula to bring back a result of November instead of month 11 without creating a list in a range of cells within the workbook?

regards
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Deano

Active Member
Joined
May 2, 2004
Messages
264
Hi Alan

Appologies for sounding dumb, but I'm not sure how to apply this formula that you are suggesting.

Is it a VBA code or an excel formula? If so, where / how do I use it?

regards
 

al_b_cnu

Well-known Member
Joined
Jul 18, 2003
Messages
4,494
Hi Deano, Sorry - didnt read your post properly :oops:

Why not just custom format the date as mmmm or mmm
 

Watch MrExcel Video

Forum statistics

Threads
1,118,799
Messages
5,574,379
Members
412,589
Latest member
ArtBOM
Top