Excel Formulas to Check Date and Roll Back to Friday If Day is Monday!!

When we enter the date, check the specified weekday for the date and roll it back to the required weekday. For example, we need to check and if it is Monday, roll back to Friday. This article provides some useful tricks to solve it. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

If you want to check the weekday of date and roll back to Friday when the date is a Monday, you can use the below formula.

=IF(WEEKDAY(date)=2,date-3,date)

Syntax Explanations:

IF – In Excel, the IF Function will return one value for a TRUE result and another for a FALSE result.
WEEKDAY – This function returns a number (ranging from 1 to 7) that represents the day of the week for a given date. Read more on the WEEKDAY function.
Date – It specifies the input dates from your worksheet.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Minus Operator (-) – This symbol will help to subtract any two values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Refer to the below example image.

Here, we will enter the input dates in Column B.
Now we have to check these dates and return to Friday when the date is Monday.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Conclusion:

From this tutorial, you can get to know how to check the date and roll back to Friday, when the date is Monday. Hope you like it. Please share your query below in the comment box. We will assist you.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **