Function Problem

Here is what I am trying to do. We get 6.67 hours a month vacation. I want a cell that will calculate 6.67 x the month. So that it will automatically change on the 1st of each month. Is there a way to do this.

Thanks

try this, and tell me if it works:

=IF(DAY(TODAY())=1),MONTH(TODAY())*6.67,"")

that formula will mulitply month (ie, Jan=1, Feb=2, etc) times 6.67

it will only do the calculation if it is the first of the month

I copied and pasted the info into a cell and it says that the formula that

you typed has an error.

OK it took that but the cell is blank. The cell should show 13.34 right?
6.67 for January 1
6.67 for February 1
13.34 total right

Why is the cell blank

It sounds like you don't need the IF statement. Try this:

=MONTH(TODAY())*6.67

=MONTH(TODAY())*6.67

That work perfectly exactly what I was looking for.

Thanks

Originally Posted by jasoncw

It sounds like you don't need the IF statement. Try this:

=MONTH(TODAY())*6.67

I considered doing it that way, but it was hard to do without more info. If he had some sort of daily total setup, I was afraid that it would add 6.67 for each day of the month.

Either way, I'm glad we found a suitable solution.