View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smilingmom Smilingmom is offline
external usenet poster
 
Posts: 3
Default Month in formula

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!