Difference of date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Atif - 06 Jan 2005 19:47 GMT

1. I have 2 columns : 1. start date 2. end date, how can I formulate in the
3rd column to show the difference in days?

2. I have dates in custom format i.e dd mmm yy but still on the formula bar
it shows as d/m/yyyy. When I type in the date 2/1/05 it shows as 01 Feb 05
whereas it should show 02 Jan 05. What could be wrong here?

TIA

Reply to this Message

Peo Sjoblom - 06 Jan 2005 20:20 GMT

You have to change the date format under the regional setting in the control
panel, if they are set to mm/dd/yy then
for 02 Jan 05 you would need to type 01/02/05 and the format will display
correctly, if you change the date
to dd/mm/yy under regional setting you can type 2/1/05 and get it correct

Signature

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

> 1. I have 2 columns : 1. start date 2. end date, how can I formulate in
> the 3rd column to show the difference in days?
[quoted text clipped - 4 lines]
>
> TIA

Reply to this Message

Nick Hodge - 06 Jan 2005 20:24 GMT

Atif

1) Use the Datedif function with the day switch "d"

=DATEDIF(A5,A4,"d")

2) I suspect the regional settings in windows are set to US. Change these,
close and re-open Excel.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> 1. I have 2 columns : 1. start date 2. end date, how can I formulate in
> the 3rd column to show the difference in days?
[quoted text clipped - 4 lines]
>
> TIA

Reply to this Message

Atif - 06 Jan 2005 20:34 GMT

Thanks Nick and Neo
Couldn't have thought of such prompt reply!

> Atif
>
[quoted text clipped - 13 lines]
>>
>> TIA

Reply to this Message

Peo Sjoblom - 06 Jan 2005 21:03 GMT

Sorry didn't see the first part, just use general format and subtract

=end-start

it is not necessary to use datedif for days

Signature

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

> Thanks Nick and Neo
> Couldn't have thought of such prompt reply!
[quoted text clipped - 16 lines]
>>>
>>> TIA

Reply to this Message

Nick Hodge - 06 Jan 2005 22:53 GMT

But I like to ;-)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Sorry didn't see the first part, just use general format and subtract
>
[quoted text clipped - 22 lines]
>>>>
>>>> TIA

Reply to this Message