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?
Microsoft Excel
Last Comment
pdvsa
Try using the networkdays function, and/or including your file.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
very nice. I have 2 parts to this question so I am about to ask a follow up..