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
8/22/2022 - Mon
nutsch
Try using the networkdays function, and/or including your file.