pdvsa
asked on
Holidays, use previous work date
Experts,
I have a spreadsheet with many columns.
I am dragging a date to the right from A1 to the last column.
If the date is any of the French holidays then I want to use the preceding work day.
the attached file is holidays in France.
How could I do this?
I have a spreadsheet with many columns.
I am dragging a date to the right from A1 to the last column.
If the date is any of the French holidays then I want to use the preceding work day.
the attached file is holidays in France.
How could I do this?
Try using the networkdays function, and/or including your file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
very nice. I have 2 parts to this question so I am about to ask a follow up..