Calculating Dates not always working

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

Guest

Hello experts,

Below is a sample of my spreadsheet. Rows 1-31 is the day of the month;
colums B, C, D, etc. are formulas, adding days to the date in A1. Up until
today, I was able to key in only a new date in A1 and the entire spreadsheet
would update. Today, it's not working at all. Any idea as to why not? I
have Excel XP 2003. I've checked the cell formats and they are correct.
Thank you for your help.

A B C D E
1 10/1/05 =a1+14 =b1+2 =c1+2 =d1+2
2 10/2/05
 
Hi!

Make sure that calculation is on automatic.

Tools>Options>Calculation

Biff
 
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

Scrabble Value calculation for Welsh words 0
Calculate elapsed time excluding specific timeframe 10
I need to do a calculation based on the values in two cells 2
SUMIF "value if false" not working 2
A function for filtering between Dates 4
Lookup next item with dates 4
Update cell value based on name and specific date 1
Conditional Formatting Dates calculating 10 days and 30 days from a certain date 2

Back
Top