| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
between dates
Hi!
How can I make the excel count between 2 dates? Thanks Horacio |
|
#2
|
|||
|
|||
|
If you want to count the days, just subtract the earlier date from the later
one. -- Vasant "Horacio" wrote in message news:1118529210.527516@localhost... Hi! How can I make the excel count between 2 dates? Thanks Horacio |
|
#3
|
|||
|
|||
|
=COUNTIF(A2:A100,"="&DATE(y,m,d)-SUMIF(A2:A100,""&DATE(y,d,m)))
-- Regards, Peo Sjoblom (No private emails please) "Horacio" wrote in message news:1118529210.527516@localhost... Hi! How can I make the excel count between 2 dates? Thanks Horacio |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| Finding dates within a date range | Excel Worksheet Functions | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
Linear Mode
