I had already written about one formula where I dealt with coming day formula - Article 3 – Show Date for a Coming Day (e.g. Coming Saturday)

I wanted to revisit this with following things in mind -

1. I wanted to explore various formulas on the above topic. Here, I am giving 2 additional formulas. So, I will be talking about a total of 3 formulas.

2. In Article 3, I talked only about Coming Day not the Previous Day. In this article, I will be talking about formulas for Previous Day also.

Also, there are two scenarios when we consider a date - If the given date is for that date itself, then whether to show that date itself or previous / next date.

For example - I have given a date 12-Jan-16 which is Tuesday. Now, in case of next Tuesday, I can show it as 19-Jan-16 and in case of previous Tuesday, I can show it as 05-Jan-16. Since 12-Jan-16 is Tuesday, I can also choose to show 12-Jan-16 itself as the Tuesday in case of next / previous Tuesday.

Note - If You need to copy and paste below formulas, download the workbook.

FORMULAS for Next Coming Day and if the date is same, show the next coming date. Reference date in A1 is 26-Jan-16 which is a Tuesday.

FORMULAS for Next Coming Day and if the date is same show that date itself. Reference date in A1 is 26-Jan-16 which is a Tuesday.

FORMULAS for Previous Coming Day and if the date is same, show the Previous coming date. Reference date in A1 is 26-Jan-16 which is a Tuesday.

FORMULAS for Previous Coming Day and if the date is same show that date itself. Reference date in A1 is 26-Jan-16 which is a Tuesday.