D Deano Active Member Joined May 2, 2004 Messages 264 Nov 17, 2005 #1 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
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
A al_b_cnu Well-known Member Joined Jul 18, 2003 Messages 4,494 Nov 17, 2005 #2 Hi, Try MsgBox MonthName(Month(Date))
D Deano Active Member Joined May 2, 2004 Messages 264 Nov 17, 2005 #3 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
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
A al_b_cnu Well-known Member Joined Jul 18, 2003 Messages 4,494 Nov 17, 2005 #4 Hi Deano, Sorry - didnt read your post properly Why not just custom format the date as mmmm or mmm
D Deano Active Member Joined May 2, 2004 Messages 264 Nov 17, 2005 #5 Works Perfectly. Thanks a million.