calculate percentage of month passed

A

Anita

I want to know how many days have lapsed in a month, every month, as a
percentage. So far we are doing it week by week, ie after the first week has
gone we say that 25% of the month has gone. We need it to be more acurate.
The problem we are having is that each month has a different amount of days.
Is there a formula we can use for this and one for the percentage of the
month left?

Thank you

Anita
 
M

Mike H

Anita,

Try this formatted as a percentage

=DAY(TODAY())/DAY(DATE(YEAR(NOW()),MONTH(NOW())+1,0))

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage of month passed formula 1
Calculating percentage growth rate from a cumulative figure 4
Percentage Increase 11
allocate resource over long period of time 0
Calculate / Report Total Project Resource Percentage 0
Month days over a time period 5
A couple questions BEFORE using Office 365 0
Variable Labor percentage based off of fixed sales +/- 1

Top