Increment Date, Month and Year as per Calendar and printing it in Excel Column

Hi there,

I need to increment Date and month as per the Calendar Month and print that in an excel column.

For E.g: For the month of March, I need to print from today’s date i.e 04.03.2021 to 31.03.2021. When next month arrives the month should get incremented and date should automatically reset to 01.04.2021, likewise I need to print it in an excel column for rest of the year. The year should also get incremented automatically once next year arrives.

This is part of an overall automation process where the Bot would run daily and other calculated values will get printed on the next column of current date.

Can someone help me with this?

Regards,
Rohan

1 Like

Hi @rohankulkarni

Please refer to the post shown below, scroll down to see previous month first date and previous month last date. Similarly, you can also look for next month first date.

1 Like