working out duration

**Muppet** · 03-14-2005, 01:44 PM

Hi,

I wondered if someone might be able to help me out. It's probably incredibly simple, but I just can't get my head around it.

In one cell I have the date 01/01/2005

In the next cell I have the date 05/01/2005

In the next cell I want it to automatically work out the duration between these two dates in days. eg: 5 days

what sum is it that i need in this 3rd column?

Help, would be much appreciated.

Thanks,

M

**neopolitan** · 03-14-2005, 02:29 PM

Well, when I tried it, I entered both dates formatted as dates in A1 and B1 and in C1 i entered =B1-A1 formatted as a number. This resulted in 120 which is the number of days between those dates.

HTH

**Muppet** · 03-14-2005, 02:37 PM

Hi,

thanks for your reply, but I'm sorry, I don't really understand what you mean..

M

**Domenic** · 03-14-2005, 03:49 PM

I'm not sure where Neopolitan got 120 days, but as he said, if A1 contains 1/1/2005 and B1 contains 5/1/2005 (assuming d/m/yyyy format), then simply...

=B1-A1+1

...and format the cell as 'General'.

Hope this helps!

**Muppet** · 03-14-2005, 04:12 PM

you're an absolute star I have cracked it in my mind at last.

Many thanks.

M

**neopolitan** · 03-15-2005, 09:45 AM

Well, I got 120 days in two ways: 1) Excel calculated that reults given the formula that I used and 2) I verified that it was correct by looking on my desk calendar and counting the days between 01/01/05 & 05/01/05.