Monthly fills

[B]

We would like to know how to do an automatic fill monthly
for a spreadsheet that is keeping track of paid,
accumulated and unpaid vacation time. For example: On the
first of each month, is it possible for excel to add 5 to
the accumulated column automatically?

 

[JE McGimpsey]

One way:

=5*DATEDIF(DATE(2004,1,1),TODAY(),"m")

Adjust your start date to suit.

DATEDIF is only documented in XL2000. See

http://cpearson.com/excel/datedif.htm

 

[Bernie Deitrick]

B,

Add this to your total formula:

DATEDIF(DATE(2003,12,1),NOW(),"m")*5

HTH,
Bernie
MS Excel MVP