MrExcel Publishing
Your One Stop for Excel Tips & Solutions

WEEKDAYS vs. Weekends/Holidays

Posted by roni on July 17, 2001 11:59 AM

Okay, let me try to explain this differently:

I need to calculate 3 months prior to a given date, not ending with a
weekend or holiday date (needs to be day before or after, whichever
weekday is closest). I've used EDATE to calculate 3 months prior, but
if it lands on a weekend or holiday, I need Excel to change to closet

Also, I need to add 10 workdays to a given date (that being the date
mentioned above), not landing on a weekend or holiday.

Any ideas? As I don't often check this board, please feel free to email
me directly at:

Thank you.

Posted by Mark W. on July 17, 2001 12:01 PM

What exactly to you mean by closest? If EDATE()
produces a date that falls on Saturday do you want
to return a Friday date (-1 offset) or will a Monday
date (+2 offset) suffice? Can the offset ALWAYS be
either postive or negative, but not both? Keep in
mind that the absolute closest work day date is
considerably more difficult to calculate in
conjuction with holidays.

Posted by Mark W. on July 17, 2001 12:11 PM

See 23459.html

Posted by Mark W. on July 17, 2001 1:26 PM

See 23459.html

Is it possible to switch from one workbook to another workbook and run a macro? Both workbooks are already open.