Difference between two dates in days

buntykins · Apr 23rd, 2002, 05:56 AM

Hi all,

I need a formula that works out the difference between two dates in days. So for instance, in A1 I have 22/3/02 and in B1 I have 28/3/02. In C1 I need it to say 6, because that's the amount of days difference between the two

Can anyone help me? I'm really stuck on it! By the way, the dates are formatted as you see above

Janie
xxxx

buntykins · Apr 23rd, 2002, 05:58 AM

It's OK I've done it! It's just one minus the other one!!!!!!

How bloody easy is that??/

Doh!

Ivan F Moala · Apr 23rd, 2002, 06:00 AM

Quote:

On 2002-04-23 04:58, buntykins wrote:
It's OK I've done it! It's just one minus the other one!!!!!!

How bloody easy is that??/

Doh!

Your'll probably need to format it as
"d" if you want to see just the day number

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 05:56 AM	#1
buntykins Board Regular Join Date: Apr 2002 Posts: 76	Hi all, I need a formula that works out the difference between two dates in days. So for instance, in A1 I have 22/3/02 and in B1 I have 28/3/02. In C1 I need it to say 6, because that's the amount of days difference between the two Can anyone help me? I'm really stuck on it! By the way, the dates are formatted as you see above Janie xxxx

Apr 23rd, 2002, 05:58 AM	#2
buntykins Board Regular Join Date: Apr 2002 Posts: 76	It's OK I've done it! It's just one minus the other one!!!!!! How bloody easy is that??/ Doh!