Formula to get previous Tuesday day date

[Sasi Kumar]

Hi,

I need an excel formula to get previous Tuesday date. Please see the below scenarios for more details on my requirement.

If the given date is 01/26/2016 then the output date should be 01/26/2016

If the given date is 01/25/2016 then the output date should be 01/19/2016

If the given date is 01/29/2016 then the output date should be 01/26/2016

Please help me with a formula.

 

[Khalid NGO]

Hi Sasi Kumar,
See if this works:

=IF(WEEKDAY(A1,1)=3,A1,A1-WEEKDAY(A1+4))

Regards,

 

[Sasi Kumar]

Thank you so much...