formula for date to land on the following Tuesday

Kim_C

Hello,

I am calculating a date based on another date:

=[Proof to LSI]70 + 49

I would like to add to this formula so that the date will always land on the following Tuesday. 

Any suggestions?

Thanks,

Kim

Tony Coleman

Have a look at this thread  sounded pretty similar.

 

Regards