Adding cells togather on a specific date

  • Thread starter Thread starter fordguy
  • Start date Start date
F

fordguy

Not sure if this is possible or i need to do a VBA or a macro or a
formula. i am working on an excell spreadsheet for my vacation. I have
a spreadsheet i am working with now and it is ok , just wanna make it
better. What i would like to have done is i get 8 hrs of leave a month
on the first of the month. i have the months running down the left
side. in rolum A a number "8" in colum B. How can i get excell to add
"8" to my running total automaticly the first time i have opened excel
after the first of the month ? Hope this wasnt to confusing thank you
 
Hello

In Column B cannot you not have the formula
=IF(A2<=TODAY(),8,0)

running down the page?

Nick
 
Something like ... ?
=IF(TODAY()<DATEVALUE("1/11/03"),A1,A1+B1)

Regards
BrianB
=============================================
 
Back
Top