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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Snooker07
  • Order by date
  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