Help change Friday to following Monday

Giganews Newsgroups
Subject: Help change Friday to following Monday
Posted by:  David (dturner4_19…@yahoo.com)
Date: Wed, 21 Jun 2006

XL2000
I currently use the following formula to return the Friday before the 17th
of the month if the 17th falls on a weekend:

=DATE(YEAR(NOW()),MONTH(NOW()),17)-MAX(0,WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW
()),17),2)-5)
(Excuse the wrapping, please)

What I would like instead, is a formula to return the date of the following
Monday if the 17th falls on a weekend. I don't want to use the Workday()
function, because the file will often be viewed on machines that don't have
the Analysis Toolpak available.

Simple for someone who knows how(?), but not for me :(

--
David

Replies