Find The Tuesday (Finish The Formula!)

Hi all,

I'm splicing together a formula from previous projects (and posts) to try and find the Tuesday in the next week from the date in cell AK9. I can get Excel to get the right date if the date is already a Tuesday, and I can get it if it's a Monday (or Sunday). What I'm having problems with is getting the date for Wednesday onwards.

The formula I've got currently looks like this:

=IF(WEEKDAY(AK9)=4,AK9+7,IF(WEEKDAY(AK9+7)<4,AK9+ 7+(4-WEEKDAY(AK9+7))...this is where I'm having problems!))

Can anyone suggest a means of completing the formula?

TIA,

SamuelT

Hello Samuel,

Can I get your requirement right? I'm assuming that if AK9 were any date this week, Monday 26th up to Friday 30th that the formula should return next Tuesday, i.e. December 4th, is that right? If so try

=AK9+9-WEEKDAY(AK9-1)

Thanks daddylonglegs - spot on!