Fixing Date Error -

**JCL622** · 01-07-2013, 10:23 AM

So the forums here have really helped me out! I have this working day calculator that helps me calculate turn-around time.

But now I'm running into trouble and I have no idea why.

The formula works great up until July 8, 2013 - after which all dates are 1/13/00 - Why does this happen and how do I fix it?

In the future, will I be able to just change the dates in H1:H6 (or even add dates) and just modify the dates in A column?

Galaxy 2013 Jan - December.xls

Thank You for all the help!

**Kevin UK** · 01-07-2013, 10:30 AM

Hi JCL622

Copy the formula down in A171

**JCL622** · 01-07-2013, 10:49 AM

What did I have to do differently? I noticed you took out all the weekend date breaks.

Also will the formula break if I change the dates? I would like to change H5 to 11/28/2013 and H6 to 12/25/2013

**JCL622** · 01-07-2013, 10:54 AM

Nevermind I think I realized what I did wrong..wow..

I set up my dates wrong and the program got confused.

Ok! new question - So for A173 I did - =+A171+3, but for A174 I will do A173+1. Is there a way to change that all the way down the column? or do I have to manually change each one?