If week begins with monday, then, if week begins on tuesday then...

[emoandy05]

Hello!

Looking for a formula or VBA to help with this.

In column L I have a list of dates in order but some dates might be missing (ex. 12/11/15, 12/12/15, 12/14/15). If a date is a Monday followed by a date that is a Tuesday, then 250 needs to go in each adjacent cell for Monday and Tuesday in column X. If a date is not a Monday, and the next date is a Tuesday is followed by a date that is a Wednesday, then 250 needs to go in each adjacent cell for Tuesday and Wednesday in column X.

Ex. 1
A B
12/13/15
12/14/15 250
12/15/15 250
12/16/16

Ex. 2
A B
1/17/16
1/19/16 250
1/20/16 250
1/21/16

Thank you!

 

[RCBricker]

change all cell references as needed

=IF(AND(TEXT(J44,"dddd")="Monday",TEXT(J45,"dddd")="Tuesday"),250,IF(AND(TEXT(J44,"dddd")="Tuesday",OR(TEXT(J43,"dddd")="Monday",TEXT(J45,"dddd")="Wednesday")),250,IF(AND(TEXT(J44,"dddd")="Wednesday",TEXT(J43,"dddd")="Tuesday"),250,"")))

rich

 

[emoandy05]

That'll work. Thank you rich.