Subtract one month from an abbreviated 3 character mont name

[wherdzik]

Is there a way to subtract one month from an abbreviated 3 character month name. For example, I have a March column identified as Mar and I want to subtract Month so that it is displayed as Feb. Is there a way to do that. Its not a full date, just 3 character text displayed month.

Thank you for checking.

[Greg M]

Hi there,

If Cell A1 contains the text value "Mar", then the following formula will display "Feb":

Please Login or Register  to view this content.

2000 is just an arbitrary year - any year could be used.


Hope this helps.

Regards,

Greg M

[TMS]

@Greg M: neat solution … and you can drag it across, even changing year. I failed miserably with the year change

[Greg M]

Hi Trevor,

Many thanks for your feedback, your kind words, and also for the Reputation increase - very much appreciated from a Guru!

Thanks for all of your contributions on here, and please keep up the good work.

Best regards,

Greg M

[wherdzik]

Thank you for your solution this works great!

[Greg M]

Hi again wherdzik,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M