determining assignment dates T-5, T-10, T-20 dates before project review

[tuxedo76]

Hello,


We always have project reviews on Mondays. In helping our client prepare for these reviews, we have provided them a "checklist":


*T-5 business days (thus, previous Monday): make sure room is reserved

*T-10 business days: (thus, two Mondays before) make sure all people are invited to meeting

*T-15 business days: (thus, three Mondays before) make sure PowerPoint is complete

Etc.


Is there some type of formula in Excel that might work to calculate these T-5, T-10, T-20 dates assuming I have the date of the project review meeting?


Thanks!


Kelly

 

[keymaster]

Use WORKDAY formula,


Assuming project review date is in cell A1,


=WORKDAY(A1,-5)

=WORKDAY(A1,-10)

=WORKDAY(A1,-15)


to get T-5, T-10 and T-15th business day.