Find the Duration
 

Hi,
How can i find the duration (No. of days) between two days.

ex. (10/20/2006 to 10/31/2006)

Thx & Regards,

Find the Duration
 

Hi

Just take the earlier data away from the later date.
="10/31/2006"-"10/20/2006"
or with dates in A1 10/20/2006 and B1 10/31/2006
=B1-A1

Add 1 to the result if you want to include the whole of the 20th and the
whole of the 31st.
Format the cell with your formula as FormatCellsGeneral.

--
Regards

Roger Govier


"Nad" wrote in message
...
Hi,
How can i find the duration (No. of days) between two days.

ex. (10/20/2006 to 10/31/2006)

Thx & Regards,

Find the Duration
 

There is also an "undocumented" formula:
=DATEDIF(A1,B1,"d")


"Nad" wrote:

Hi,
How can i find the duration (No. of days) between two days.

ex. (10/20/2006 to 10/31/2006)

Thx & Regards,

Find the Duration
 

Thanks Roger
Its working fine.
Also i want to add days to any date.
e.g. (adding 5days to 10/20/2006 i.e it should be 10/25/2006)

Thx again,

"Roger Govier" wrote:

Hi

Just take the earlier data away from the later date.
="10/31/2006"-"10/20/2006"
or with dates in A1 10/20/2006 and B1 10/31/2006
=B1-A1

Add 1 to the result if you want to include the whole of the 20th and the
whole of the 31st.
Format the cell with your formula as FormatCellsGeneral.

--
Regards

Roger Govier


"Nad" wrote in message
...
Hi,
How can i find the duration (No. of days) between two days.

ex. (10/20/2006 to 10/31/2006)

Thx & Regards,

Find the Duration
 

Simply use the plus sign to add. If 10/20/2006 is in A1, use:

=a1+5

to get 10/25/2006.

--
Regards,
Fred


"Nad" wrote in message
...
Thanks Roger
Its working fine.
Also i want to add days to any date.
e.g. (adding 5days to 10/20/2006 i.e it should be 10/25/2006)

Thx again,

"Roger Govier" wrote:

Hi

Just take the earlier data away from the later date.
="10/31/2006"-"10/20/2006"
or with dates in A1 10/20/2006 and B1 10/31/2006
=B1-A1

Add 1 to the result if you want to include the whole of the 20th and the
whole of the 31st.
Format the cell with your formula as FormatCellsGeneral.

--
Regards

Roger Govier


"Nad" wrote in message
...
Hi,
How can i find the duration (No. of days) between two days.

ex. (10/20/2006 to 10/31/2006)

Thx & Regards,