Dates

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

Guest

How do i calculate the number of days between 3 dates, 09/01/2006 thru 01/23/06
 
Just subtract:

A1 = 9/1/2006
A2 = 1/23/2006

=A1-A2

Format as GENERAL or NUMBER

Result = 221

Biff
 
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

UNABLE TO SORT DATE 1
counting based on two dates 2
Summary of Difference between dates in years, months, days 3
Count Dates between Dates exclude Text 3
Formula - to accumulate the number of data appear 2
Count based on multiple criteria 2
Dates & Text? 6
Counting Cells with Multiple Range Criteria (Excel 2003) 7

Back
Top