Avatar of pdvsa
pdvsa
Flag for United States of America 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?
Microsoft Excel

Avatar of undefined
Last Comment
pdvsa

8/22/2022 - Mon
nutsch

Try using the networkdays function, and/or including your file.
ASKER CERTIFIED SOLUTION
barry houdini

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pdvsa

ASKER
very nice.  I have 2 parts to this question so I am about to ask a follow up..
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck