vegas86
asked on
Help with MONTH formula
Hello,
Does anyone know how I can get the =MONTH formula to return ‘mmm’ instead of the number value?
For example instead of ‘1’ I would prefer ‘Jan’. I have attached an example of what I am talking about. I need column B to return the month from column C.
example.xlsx
Does anyone know how I can get the =MONTH formula to return ‘mmm’ instead of the number value?
For example instead of ‘1’ I would prefer ‘Jan’. I have attached an example of what I am talking about. I need column B to return the month from column C.
example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works perfectly! thank you Teylyn!!
=C3
and format the result with
mmm
Then only the month portion of the date will show in the cell, with three letter month abbreviation.
cheers, teylyn