=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