# Excel formula help

I had this formula created for me a few years ago.  I need to know exactly what is is calculating.  See screen shot of spread sheet.

=H3/(DAY(DATE(YEAR(H\$2),MONTH(H\$2)+1,0))*24)
excel.png
rspahitz

Hmmm...let's see...guessing about H2 and H3 but...

YEAR(H\$2) gets the year portion of the date in that cell

MONTH(H\$2)+1 gets the month portion of that cell and adds one (so determine next month)

DATE(YEAR(H\$2),MONTH(H\$2)+1,0) will convert the information into next month as a date

DAY(DATE(YEAR(H\$2),MONTH(H\$2)+1,0)) gets the number of days in the next month

...*24 will calculate hours for that range

H3/... will divide the number of hours next month by some number, maybe for payroll purposes?

So per month how many hours or days is it calculating?  If you look at the attachment each months hours are different and all equal 100%.  That's where I'm confused.
Patrick Matthews

membership
Create an account to see this answer
Signing up is free. No credit card required.