Business day math

Topic

New Reply

I know that the networkdays function will calculate the number of workdays between two dates but how do I determine a date that is X business days before or after a particular date? For example, full payment is due 7 business days prior to delivery date. If the delivery date is known, I would like to have Excel calculate the date full payment is due.

Reply | Quote

Replies

You can use the WORKDAY function – see WORKDAY – Excel – Microsoft Office Online.

Reply | Quote

You can use the WORKDAY function – see WORKDAY – Excel – Microsoft Office Online.

Thanks Hans – just what I needed.

Reply | Quote