Formula???

[mermar]

I am creating a self-adding absentee calendar for employees. I am having a problem with a formula; =SUMIF((I7>(TODAY))(Y26*M$8)). This means that if the date entered in I7 is greater then today, vacation should accrue for hours worked times rate.

 

[jmthompson]

Try this

=IF(I7<=TODAY(),Y26*M$8,0)

 

[mermar]

Thanks, that worked!