The x values can be 1 to 12?

=(6.67*month(today())-0.04



Smilingmom wrote:

I have a formula where I calculate the number of hour accrued based on the
month of the year. Currently, I have to physically go in and change the
number. Is there a formula I can add to this to make it change automatically
based on the current month? The formula is below where X is the current
month (number).

=(6.67*X)-0.04

Thanks for the help!

--

Dave Peterson