J.R. Sitman

asked on

# 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

=H3/(DAY(DATE(YEAR(H$2),MO

excel.png

ASKER

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.

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

So total hours meaning 31 or 30 or 28 days time 24 hours?

Correct

ASKER

Thanks

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)+

DAY(DATE(YEAR(H$2),MONTH(H

...*24 will calculate hours for that range

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