Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |