Date Formula

Michael Pierson

I have a formula that subtracts 5 days from an entered date to give me a due date. The days I subtract do not count Sundays or Holidays. However, if the due date falls on a Saturday, I need it to subtract one more day. No due date can be on a Saturday. I am not able to create a formula to recognize Saturday and minus one day. Can you help me with a formula for this?

Nik Fuentes

something like =if(Weekday(Date1-5)=7,Date1-6,Date1-5) might work.

Nik Fuentes

something like =if(Weekday(Date1-5)=7,Date1-6,Date1-5) might work.

Michael Pierson

Thanks Nik. I think I will be able to make this work.