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?