Calculate Date before Due Date

[marilive]

Anyone know a formula to figure out the date prior to due date? ie due date
is Nov 20 but need to find out what the date is 60 BUSINESS days prior to
Nov. 20. Tried using Workday function but something must be wrong with
formula: =workday("11/20/2004", -10)

 

[Paul Corrado]

With the date 11/20/2004 in Cell A1 you can use the formula

=A1-60

Or

You can use the formula

=DATE(2004,11,20)-60

 

[marilive]

Thanks for the formula but I needed it to calculate business days (minus
weekends and holidays). Is there an easy way to modify the formula? Thanks,
again!

 

[Frank Kabel]

Hi
=WORKDAY(A1,-60)

Note: you have to install the Analysis Toolpak Addin to use this
function