finding 75 days before current date

[vikkib]

I need to figure out a formula to figure out 75 workdays before the current
date.

 

[Rick Rothstein \(MVP - VB\)]

You will need to have the Analysis ToolPak Add-In active (Tools/Add-Ins on
Excel's menu bar for XL2003 and earlier; XL2007 includes the WORKDAY
function standard)...

=WORKDAY(A1,-75)

Look it up in the help files as you can account for holidays with this
function as well.

Rick

 

[Ron Rosenfeld]

I need to figure out a formula to figure out 75 workdays before the current
date.

Look at the WORKDAY function in HELP.

Your formula will be something like:

=WORKDAY(TODAY(),-75)

and there is an optional holidays argument.

If you get a #NAME! error, reread HELP for the WORKDAY function for the
solution.
--ron

 

[Rick Rothstein \(MVP - VB\)]

You said current date, didn't you? Change the A1 to the TODAY() function..

=WORKDAY(TODAY(),-75)

Rick