Hi I need help with a formula
I'am trying to calculate a work date 42 days after an episode start date.
So the start dates are in Day, Month, year (all drop downs boxes)
when I put in the formula-
=WORKDAY(w45,42) and the start day is 1/1/2017
the answer comes back with 1/1/1900 !!
What am I doing wrong with the year?
Thanks for your help
Barbara
Solved by B. S. in 27 mins