45 day payment

[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.
How would I do that?
Thanks,

 

[joeu2004]

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.

 

[Claus Busch]

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