How to read previous month in excel sheet?

[SIM_JUN_HUI_BERTRAM_CSOD]

Hey guys im stuck and not sure how to go to the prev month excel sheet. For example if this month is July i want to go to the previous month which is JUN21. Then it will be the same for the rest of the month if it is August it will go to JULY21 sheet.

This is my process for reading each excel sheet to find the previous month sheet but im not sure what is the forumla for it to find it

[Yoichi]

Hi,

Can you try the following expression?

Now.AddMonths(-1).ToString("MMMyy").ToUpper

Regards,

[SIM_JUN_HUI_BERTRAM_CSOD]

Thanks for the forumla this works !!