I need a way to enter a date (06/20/11) and have excel compute 45
days from that date and give a date of the nearest Monday to that
date. Thursday or earlier would go back to that weeks Monday date and
Friday or later would go to the upcoming Monday after that date.
How would I do that?
Thanks,

On Jun 20, 6:08*am, Rudyeb <rudyeb...@gmail.com> wrote:
> I need a way to enter a date (06/20/11) *and have excel
> compute 45 days from that date and give a date of the
> nearest Monday to that date. Thursday or earlier would
> go back to that weeks Monday date and friday or later
> would go to the upcoming Monday after that date.

If A1 contains the base date (6/20/2011), one way is:

=A1+45+IF(WEEKDAY(A1+45,3)<=3,-WEEKDAY(A1+45,3),
7-WEEKDAY(A1+45,3))

formatted as Date.

Hi Rudy,

Am Mon, 20 Jun 2011 06:08:57 -0700 (PDT) schrieb Rudyeb:

> I need a way to enter a date (06/20/11) and have excel compute 45
> days from that date and give a date of the nearest Monday to that
> date. Thursday or earlier would go back to that weeks Monday date and
> Friday or later would go to the upcoming Monday after that date.

your Date in A1. Then try this:
=A1+45+CHOOSE(WEEKDAY(A1+45,2),0,-1,-2,-3,3,2,1)



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2