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