45 day payment

  • Thread starter Thread starter Rudyeb
  • Start date Start date
R

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,
 
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.
Click to expand...

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.
Click to expand...

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



Regards
Claus Busch
 
Back
Top