date formula not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings

Q1
b1 has date manually inputted in format 12-Feb-03; b2 has formula '= b1+10' to get the new date; when a new date is updated in b1, b2 does not re calculate new date.

Suggestions please

....a
 
Hi
maybe you have disabled the automatic calculation mode. Will th date
change if you hit F9. You can check this option under 'Tools -
options - calculation'

Frank
 
Back
Top