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

Hi Anita,

Yes, there is a formula you can use to calculate the percentage of the month that has passed. Here are the steps:

1. First, you need to determine the total number of days in the current month. You can do this by using the
   Formula:

   EOMONTH 

   function. For example, if you want to calculate the percentage of days that have passed in the current month, you can use the following formula:
   
   =EOMONTH(TODAY(),0)-DATE(YEAR(TODAY()),MONTH(TODAY()),1)+1
   
   This formula will give you the total number of days in the current month.
   
2. Next, you need to determine the number of days that have passed in the current month. You can do this by using the
   Formula:

   TODAY 

   function to get the current date, and then subtracting the first day of the month from it. For example:
   
   =TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),1)+1
   
   This formula will give you the number of days that have passed in the current month.
   
3. Finally, you can calculate the percentage of the month that has passed by dividing the number of days that have passed by the total number of days in the month, and then multiplying by 100. For example:
   
   =(TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),1)+1)/(EOMONTH(TODAY(),0)-DATE(YEAR(TODAY()),MONTH(TODAY()),1)+1)*100
   
   This formula will give you the percentage of the month that has passed.
   

To calculate the percentage of the month left, you can simply subtract the percentage of the month that has passed from 100. For example:

=100-(TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),1)+1)/(EOMONTH(TODAY(),0)-DATE(YEAR(TODAY()),MONTH(TODAY()),1)+1)*100

Anita,

Try this formatted as a percentage

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

Mike

"Anita" wrote:

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

=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''.


"Anita" wrote:

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

On Wednesday, September 9, 2009 at 7:52:15 PM UTC+1, Mike H wrote:
Anita,

Try this formatted as a percentage

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

Mike

"Anita" wrote:

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

That worked great for me thanks

On Wednesday, September 9, 2009 at 8:40:12 AM UTC-10, Anita wrote:
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

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

On Wednesday, September 9, 2009 at 1:52:15 PM UTC-5, Mike H wrote:
Anita,

Try this formatted as a percentage

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

Mike

"Anita" wrote:

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

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