Formula ?

[zone709]

Hi this formula gives me 7/23/2017 and changes this Sunday to 7/30/2017. It changes every Sunday.

What I need help for it to do is to wait till Tuesday to change the date.

So example: I need it to change to 7/23/2017 when Tuesday hits meaning tomorrow rather then it change on a Sunday and then change it when next Tuesday comes around to 7/30/2017.

Any help thanks


=TODAY()-WEEKDAY(TODAY())+1

 

[joh07956]

Will this do the trick?

=IF(WEEKDAY(TODAY())>=3,TODAY()-WEEKDAY(TODAY())+1,TODAY()-WEEKDAY(TODAY())+1-7)

 

[Marcelo Branco]

Maybe...

=TODAY()-WEEKDAY(TODAY()+5)-1

M.

 

[Tetra201]

Try this:

=TODAY()-WEEKDAY(TODAY(),12)-1

 

[zone709]

Hi guys thanks for the reply. I put all 3 formulas in 3 different cells and they all say 7/16/2017. If these are right tomorrow it will change to 7/23/2017. Thanks again cheers

 

[zone709]

Hi guys back here yes I actually needed this for one of my sheets, but I just realized now that I used this formula in another sheet but need similar but different results. Every Tuesday I need it to give me this weeks Sunday date. So today is Wednesday should be returning 7/30/2017. Then next Tuesday would be August 1st I need it to change to 8/06/2017. I'm going ahead this time. thanks

 

[Marcelo Branco]

Add 7 on each formula. So my formula (post #3) becomes
=TODAY()-WEEKDAY(TODAY()+5)+6

M.

 

[zone709]

Thanks for the help works