count period between dates

  • Thread starter Thread starter Scot B
  • Start date Start date
S

Scot B

Greetings,

I have dates in two different cells and am looking for a formula that will
tell me the number of days between each date. The periods are only 30-45
days so I don't need to account for leap years.

Can you help me?

Thanks,

Scot B.
 
One way:

Dates are just integer offsets from a base date, so you can do regular
math with them. Assuming your dates are in A1 and A2:


A3: =A1-A2

Format A3 as General or another number format.
 
Scot,

You can simply subtract one date from another to return the
number of days between the two. Be sure to format the result cell
as numeric.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
or put the following function in the cell where you want the number o
days to appear.


=DATEDIF(A1,B1,"D") where cell A1 contains the first date and cell B
contains the second.



Rolli
 
Back
Top