count period between dates

[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.

 

[JE McGimpsey]

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.

 

[Chip Pearson]

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

 

[Rollin_Again]

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