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...
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
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.