Date counting formula

D

Domenic

Hi,

try DATEDIF(start_date,end_date,"D")

For example,

=DATEDIF("6/10/2004","6/12/2004","D")

Hope this helps!
 
F

Frank Kabel

Hi
just subtract the date values (and maybe adjust accordingly to include
or exclude these dates).
e.g.
A1=06/01/2004
A2=06/03/2004

Now use the following formula in A3
=A2-A1
and format this cell as number.
This would return '2'. If you only want to count the numbers between
both dates use
=A2-A1-1
 

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

Expanding Date Formula 0
Using <= in countifs statement 1
Countif or other formula needed for multiple data/critera results 3
Dcount -Date Criteria - Won´t find it - 0
Count Number of Unique Cells That Don't Have Certain Characters 0
How to count the numbers in a Word document? 0
Display weeks from a Milestone 0
countifs Function not giving desired result with date criteria 2

Top