Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Snooker07

  1. Snooker07

    Count days between two dates??

    Hello and thank you! I am sure this will be very simple for most all of you. I need to count days beween two date ranges excluding weekends, for example: 04/28/2009 to 04/30/2009 Result should be 2 04/28/2009 to 05/04/2009 Result should be 3 Thank you and much appreciated...
  2. Snooker07

    Count days between dates...and exclude weekends?

    Hello and thank you for taking your time to read this. I am using Cryst reports 2008 and am trying to come up with a formula to count days in between two dates...and exclude weekends. Any help would be appreciated. Thank you again Todd
  3. Snooker07

    To count specific numbers on a seperate tab.

    I have a spreadsheet with two tabs, the first tab (called "Master Lost") has a row with numbers in it like 100,200,300... The next tab (Called "Summary")I want to be able to count all cells that have a 200 in it from the "Master Lost" tab. ( I do not want to add the numbers...I just want to...
  4. Snooker07

    Looking for a formula to count dates in between a range.

    Sure thing, the formula I actually used is the following. =IF(L10>39763,IF(L10<39782,1,"")) This gave me a "1" or a "False".....then I summed the Colum to get my count. I came accross this formula before anyone replied. Thank you.
  5. Snooker07

    Looking for a formula to count dates in between a range.

    GOT IT...Thank you so much!!!
  6. Snooker07

    Looking for a formula to count dates in between a range.

    Hello, I am looking for a formula to count dates in between a range. for example I have a colum with dates ranging from 11/17/2008 to 12/31/2008. Over on the next colum I want to say..if any of these dates are between 11/17/2008 and 11/24/2008 then give me a 1, or nothing. This way I can...

Part and Inventory Search

Back
Top