I have a row of 8 dates. I would like to list a given number of working days (i.e monday to friday) above these dates. So for example the last 5 working days BEFORE a particular cell.
Is this possible? So for example cell A10 and B10 and C10 ect ect all have random dates in them. Now i need a function to add the weekdays EXCLUDING saturday and sunday above each of the dates in each of the columns.
I am very keen to see the answer to this one. I did check ozgrids site but cannot seem to find it.
Much appreciated.
Add / Subtract X Weekdays From Date



Re: Weekday Function Array
Hi Danny, try searching the Excel help for "Work Day"...
use the WORKDAY function...
=WORKDAY(A10,7)
will add 7 working days (non weekend/holidays) to the date stored in A10.
=WORKDAY(A10,7)
will subtract 7 working days (non weekend/holidays) to the date stored in A10.
Ger[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]By the way, what does this have to do with your title "Weekday Function Array"
(where does an array come into it?)
Ger

Re: Weekday Function Array
Be aware that you need to have the Analysis Toolpak installed to use the WORKDAY function if on xl2003 or below  install it via Tools>AddIns and check it in the list dialog that will open.
Richard

Re: Weekday Function Array
Thanks Richard, forgot that...
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!