Sasi Kumar
New Member
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.
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.