Excel Workback Date Macro/Formula Help!

[jpmartinez]

I am creating a workback schedule for marketing, I was wondering if
there is an easy way to formulate days or dates back from a particular
date.

For example, if I have a deadline on 2/23/2004, then my copy editors
need to have a deadline of -5 or 5 (2/16/04) business days from that
date.

Does that make sense? Even if it is not business days, it would still
be helpful.

Email me with any questions.

Thanks,
JPM

 

[Frank Kabel]

Hi
without looking for business day simply subtract 5 from your date and
format the resulting cell as date. For calculation with dates have a
look at:
http://www.cpearson.com/excel/DateTimeWS.htm

In your case simply subtract 7 days from your current date (the same
as -5 business days)

Frank

 

[Peo Sjoblom]

=Cell_with_deadline-5

 

[JE McGimpsey]

If you have the Analysis Toolpak Add-in loaded (Tools/Addins...):

=WORKDAY(A1, -5)