calculate percentage of month passed

[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

[Mike H]

Anita,

Try this formatted as a percentage

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

Mike

[ryguy7272]

=MONTH(A1)/DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

[simonj...@gmail.com]

That worked great for me thanks

[cdr.ck...@gmail.com]

Try this formula ... may be simpler ...
=day(A1)/day(eomonth(a1,0))

On a similar vein, to determine the percentage remaining in a month ...
=1-day(A1)/day(eomonth(a1,0))

Chuck

[carrasc...@gmail.com]

HI Mike, Thank you for sharing. I'm in need of the same thing. How can it be linked to a date? One cell with the beginning date and one end date. Thank you