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
 
You must log in or register to reply here.

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

Can I use the NOW() function in a formula? 2
Comparison of columns using Conditional Formatting 3
separating date and time 5
Formula help 7
countifs Function not giving desired result with date criteria 2
Help needed with a formula for dates in excel 2007 2
Count entries in the column translating to minutes. 5
Conditoinal formatting 2

Back
Top