Excel Formulas to Check Date and Roll Back to Friday If Day is Monday!!
Tags: excelformula, excelformulas
Published: 2021-05-24 11:16:55

---
title: Excel Formulas to Check Date and Roll Back to Friday If Day is Monday!!
published: true
date: 2021-05-24 06:02:54 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![If Monday, roll back to Friday](https://geekexcel.com/wp-content/uploads/2021/05/If-Monday-roll-back-to-Friday.png)](https://geekexcel.com/excel-formulas-to-check-date-and-roll-back-to-friday-if-day-is-monday/if-monday-roll-back-to-friday/#main)<figcaption id="caption-attachment-45504">If Monday, roll back to Friday</figcaption>

## 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](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([WEEKDAY](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)(date)=2,date-3,date)**

## Syntax Explanations:

- **IF** – In Excel, the **[IF Function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** 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](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)**.
- **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.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-29.png)<figcaption id="caption-attachment-45505">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-76.png)<figcaption id="caption-attachment-45507">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-71.png)<figcaption id="caption-attachment-45506">Result</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Quarter from the Given Date ~ Easy Tips!!](https://geekexcel.com/excel-formulas-to-calculate-the-quarter-from-the-given-date/)**
- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**
- **[How to Enter a Time in Excel Worksheet? ~ A Useful Guide!!](https://geekexcel.com/enter-a-time-in-excel/)**