date formula not working

A

abs

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
 
F

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Can I use the NOW() function in a formula? 2
separating date and time 5
countifs Function not giving desired result with date criteria 2
Auto copying text 0
Turning off automatic calculation 0
Conditoinal formatting 2
Help needed with a formula for dates in excel 2007 2

Top