Network Days
Solved/Closed
Related:
- Network Days
- Skype last seen days ago - Guide
- Error network error occurred - Guide
- Network card - Guide
- Network refresh code - Guide
- Windows network commands cheat sheet - Guide
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
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
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
Feb 15, 2010 at 08:56 AM
Also, how can i get the formula to excluse a list of known public holidays?? any ideas, please??
Feb 15, 2010 at 09:19 AM
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)
Feb 15, 2010 at 09:38 AM