# Network Days

Solved/Closed
Jay - Feb 15, 2010 at 06:24 AM
jay - Feb 15, 2010 at 09:38 AM
Hello,

I need some help if any one can assist, please...

I have a date in a Excel S/S so i.e. 15/02/2010 and under this i have a number of days i.e. for arguements sake 10. I need a formula that will effectively subtract 10 working days from the date, in this case 15/02/2010. Hence the result returned should be 01/02/2010.

Any help on this is much appreciated...THANKS!!

## 1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 15, 2010 at 07:54 AM
To calculate the work day lapse, you can use WORKDAY function

Let say your date is in A1 (say 15/02/2010)
and your days gap is in A2 (say 10)

to count back 10 working days
=WORKDAY(A1, -A2)

to count forward 10 working days
=WORKDAY(A1, A2)

you may have to format the cell to date format of your desire
Thanks.

Also, how can i get the formula to excluse a list of known public holidays?? any ideas, please??
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > jay
Feb 15, 2010 at 09:19 AM
If you want to account for the holidays too, the best way would be to have on a separate sheet all the holidays for the year.

Then select all the days and give a "NAME" to it, lets says you name that selection as "Holidays"

then you can use the formula as

to count back 10 working days, with keeping holidays under consideration
=WORKDAY(A1, -A2, Holidays)

to count forward 10 working days, with keeping holidays under consideration
=WORKDAY(A1, A2, Holidays)

Again if you dont care for holidays, then you can use

to count back 10 working days
=WORKDAY(A1, -A2)

to count forward 10 working days
=WORKDAY(A1, A2)
jay > rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022
Feb 15, 2010 at 09:38 AM
Excellent, worked a trick. Thanks mate, appreciated.