Calculate Date before Due Date

M

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)
 
P

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
 
M

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!
 
F

Frank Kabel

Hi
=WORKDAY(A1,-60)

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