0

enter image description here

When i set date in Last FollowUp date, in Next FollowUp date needs to generate automate date.

If in Last FollowUp date is monday in Next FollowUp date needs to generate next Wednesday

If in Last FollowUp date is Wednesday in Next FollowUp date needs to generate next Friday.

If in Last FollowUp date is Friday in Next FollowUp date needs to generate next Monday.

Improve this question
2
  • What about the other days of the week?
    – Martin Lezer
    Jan 9, 2017 at 12:44
  • Need just for this 3 for now...
    – Igor Stosic
    Jan 9, 2017 at 12:53

1 Answer 1

Reset to default
1

The formula you need is (Case 1 is Monday, Case 3 is Wednesday, Case 5 is Friday):

CASE(
  MOD(YourDate - DATE( 1900, 1, 7 ), 7 ),
  1, DATE( YEAR( YourDate ), MONTH( YourDate  ), DAY( YourDate ) + 2 ),
  3, DATE( YEAR( YourDate ), MONTH( YourDate  ), DAY( YourDate ) + 2 ),
  5, DATE( YEAR( YourDate ), MONTH( YourDate  ), DAY( YourDate ) + 3 ), 
  YourDate
)
Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .