Find the Duration

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Thx & Regards,
 
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 Format>Cells>General.
 
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,
 
Simply use the plus sign to add. If 10/20/2006 is in A1, use:

=a1+5

to get 10/25/2006.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

workday calculation for backwards 1
Matching call data based on date, time and number called to give c 1
Allocation of values by time 3
Days Difference Between two days 3
Pivot with totals on top 10
Subtracting a duration from a time to calculate a time. 5
day of the week and date formula 2
Formula help: Duration Without Weekend Days 4

Back
Top