date calculation help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S - 30 May 2008 08:00 GMT

A1 I have 01/01/08 (1st Jan)
A2 I have 14/01/08 (14th jan)

How do I get A3 to show 14 days, ie I want to subtract one date from another
but show the answer in days.

thanks

Reply to this Message

G Lykos - 30 May 2008 08:05 GMT

What do you get for "=A2-A1" in A3?

> A1 I have 01/01/08 (1st Jan)
> A2 I have 14/01/08 (14th jan)
[quoted text clipped - 3 lines]
>
> thanks

Reply to this Message

S - 30 May 2008 08:16 GMT

My apologies I never changed the cell format in A3, now works.

> What do you get for "=A2-A1" in A3?
>
[quoted text clipped - 6 lines]
>>
>> thanks

Reply to this Message