Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 30th 04, 07:44 AM
Sachin Pawar
 
Posts: n/a
Default count the no.of records between two dates

I need help on Some Excel functions that can help me to solve above subject.
I am creating a testing template . In which i have to count the no.of
records that comes between two days.
eg. 10/29/2004 & 10/30/2004.
I am looking for your suggestion.

Thanking you
Sachin Pawar.

  #3   Report Post  
Old October 30th 04, 01:19 PM
Don Guillett
 
Posts: n/a
Default

try this where a1 and a2 contain your start/stop dates
=sumproduct((rngA=a1)*(rngA<a2))

--
Don Guillett
SalesAid Software

"Sachin Pawar" <Sachin
wrote in message
...
I need help on Some Excel functions that can help me to solve above

subject.
I am creating a testing template . In which i have to count the no.of
records that comes between two days.
eg. 10/29/2004 & 10/30/2004.
I am looking for your suggestion.

Thanking you
Sachin Pawar.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM
due dates Niki New Users to Excel 4 January 10th 05 04:11 PM
I get wrong dates when i paste from a different sheet into a new s mmollat Excel Discussion (Misc queries) 2 January 6th 05 07:35 PM
How do a count dates? Aviator Excel Discussion (Misc queries) 2 January 5th 05 04:17 PM
How do a count dates? Peo Sjoblom Excel Discussion (Misc queries) 0 December 27th 04 05:13 PM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017