Network Days
Solved/Closed
Related:
- Network Days
- Skype last seen days ago - Guide
- What is a network card - Guide
- Error network error occurred - Guide
- Wpan network - Guide
- Network refresh code - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
15 Feb 2010 à 07:54
15 Feb 2010 à 07:54
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
15 Feb 2010 à 08:56
Also, how can i get the formula to excluse a list of known public holidays?? any ideas, please??
15 Feb 2010 à 09:19
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)
15 Feb 2010 à 09:38