View Single Post
 
Old 01-10-2021, 06:26 AM
PM1 PM1 is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2020
Posts: 8
PM1 is on a distinguished road
Default

Charles,

Thanks you for your kind assistance.

In the end I used
Code:
{QUOTE{=MOD({DATE \@ M}+10,12)+1}/0 \@ MMMM}
to fullfill my requirement.



For anyone else who may be interested


Code:
For this month: {DATE \@ MMMM}
For next month: {QUOTE{=MOD({DATE \@ M}+12,12)+1}/0 \@ MMMM}
 For last month: {QUOTE{=MOD({DATE \@ M}+10,12)+1}/0 \@ MMMM}


To get just the 3 letter code for the month, replay MMMM with MMM
Reply With Quote