Get abbreviated month by date

LUIS FREUND
LUIS FREUND used Ask the Experts™
on
Wanted to get the abbreviated month name based on a date.

In column J is the date and in columns N,O,P I wanted the abbreviated month listed based on the year.  

Please see attachment for example.
C--Users-lfreund-Documents-MONTH---.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Hi Luis,

Please try this...

In N2
=IF(YEAR($J2)=N$1*1,TEXT($J2,"mmm"),"")

Open in new window

and then copy it across and down.
C--Users-lfreund-Documents-MONTH.xlsx

Author

Commented:
PERFECT!!!!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Thanks for the feedback Luis!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial