finding 75 days before current date

R

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
 
R

Ron Rosenfeld

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
 
R

Rick Rothstein \(MVP - VB\)

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

=WORKDAY(TODAY(),-75)

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calendar Logic: Recurring Dates 3
Display weeks from a Milestone 0
Help using the Workday Function 1
Value of the first day of a year in a list 5
Macro to select and delete levels of a document 2
Consecutive date calculation involving holidays 1
Append Crosstab Query to Existing Table 0
FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE 2

Top