A1: start date
A2: end date

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)<5))


"Shelly" wrote:


What I need to do is have a project start date and an end date and a
duration of days. We work a 4 day work week here and I need to not count
Friday (Sat or Sun) in the duration of the projects. I just need a correct
end date for the projects.

Thanks so much!!!