excel如何自动输入当前日期之后的固定的某天

Question

如，想在一个单元格中输入一个日期，此日期固定为当前日期后的第一个星期三，该如何运用函数？
目前我使用的方法如下：
=IF(WEEKDAY(today(),2)=1,E8+2,IF(WEEKDAY(today(),2)=2,E8+1,IF(WEEKDAY(today(),2)=5,today()+5,IF(WEEKDAY(today(),2)=4,today()+6,IF(WEEKDAY(today(),2)=3,today()+7,IF(WEEKDAY(today(),2)=6,today()+4,IF(WEEKDAY(today(),2)=7,today()+3,"")))))))
虽然能够达到目的，但是感觉很蠢，请高人提示更简明快捷的方案，谢谢。

Answer 1

=TODAY()+MOD(9-WEEKDAY(TODAY(),2),7)+1