formula to obtain difference between two dates.

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

Guest

i need a formula/function to calculate the difference between two dates in
microsoft excel worksheet.
 
=(EndDate-Startdate) and format cell as General [or Custom=>d] to give
difference in days.

=(B1-A1) where B1=17/06/2006 and A1 = 0106/2006 will produce result of 16

HTH
 
See the "Designate valid cell entries" in the Help.
The function lets you to select a list of menu entries - in the Help there
is a whole host of options.

Toppers píše:
=(EndDate-Startdate) and format cell as General [or Custom=>d] to give
difference in days.

=(B1-A1) where B1=17/06/2006 and A1 = 0106/2006 will produce result of 16

HTH

Onkar Raut said:
i need a formula/function to calculate the difference between two dates in
microsoft excel worksheet.
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

Calculate elapsed time excluding specific timeframe 10
Difference between dates 9
Copying formulas across columns 2
DATEDIF vs. simple difference 5
Excel Microsoft excel interest formula 2
Date question 3
conditional formula based on dates 4
percentiles? 1

Back
Top