Creating an Indicator of Passed Days

Need: I want to calculate the percentage of days that have passed from the current month.

 

Solution: Use the following formula:

=DAY(TODAY())/DAY(EOMONTH(TODAY(),0))

This formula calculates the number of days passed from this month then divides it by the total days of that month. It takes into consideration the number of days in each month (i.e. 30 or 31) so you don't have to change the days manually.

However, to calculate the progress of a project towards a certain deadline or how many days have passed out of total project duration, you can use the following formula:

 

	A	B
2	Project Start Date	12-07-2019
3	Project End Date	31-08-2019

 =(TODAY()-B2)/(B3-B2)