finding 75 days before current date

  • Thread starter Thread starter vikkib
  • Start date Start date
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
 
I need to figure out a formula to figure out 75 workdays before the current
date.
Click to expand...

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
 
You said current date, didn't you? Change the A1 to the TODAY() function..

=WORKDAY(TODAY(),-75)

Rick
 
Back
Top