Previous Topic Next Topic

Excel Sheet Counter

Closed
SM - Jun 3, 2010 at 02:36 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2010 at 03:06 PM
Hello,
I want to count days, exclude Sat.and Sun and Stat. holidays and have the program tell me the date 20 days, 40 days down the line.

eg. I put in June 3, 2010 I want the program to tell me the date 14 days (with exclusion not counted) Answer June 23, 2010

If I changed the 14 to 13 or 50 the program changes the date accordingly.

thanks
sm

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 3, 2010 at 03:06 PM
What version of excel are we talking about here.
0