Hello,
I am working on an excel formula to calculate the % of month completed by today or current date. The start date is the 1st of each month, and the end date is the last day of each month. Any suggestions how to write it out?
I started with the following:
=DAY("2022-03-11")/DAY(EOMONTH("2022-03-30",0)) -- = 35% of month booked
But, I am wondering if it's possible to not have to go in each time to adjust the date manually, but to insert 'TODAY' somehow to update the % of month completed automatically?
Thank you!
I am working on an excel formula to calculate the % of month completed by today or current date. The start date is the 1st of each month, and the end date is the last day of each month. Any suggestions how to write it out?
I started with the following:
=DAY("2022-03-11")/DAY(EOMONTH("2022-03-30",0)) -- = 35% of month booked
But, I am wondering if it's possible to not have to go in each time to adjust the date manually, but to insert 'TODAY' somehow to update the % of month completed automatically?
Thank you!