Learn How to Get Max Value In a Given Weekday in Microsoft Excel
The main purpose of this formula is to find the maximum value on a given weekday, that is – Monday, Tuesday, Wednesday, and so on. Here we will learn how to get the maximum value in the given weekday in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the MAX, IF, and TEXT functions, you can able to find the maximum value on a given weekday.
So, with the help of this formula, you can able to get the maximum value in the given weekday in the given data range in the workbook in Microsoft Excel.
General Formula to Get Max Value In a Given Weekday
{=MAX(IF(TEXT(dates,”ddd”)=”Mon”,values))}
The Explanation to Get Max Value In a Given Weekday
So we know that with the help of the given formula above, you can able to find the maximum value on a given weekday, that is – Monday, Tuesday, Wednesday, and so on.
Here we will learn how to get the maximum value in the given weekday in the given data range in the workbook in Microsoft Excel. As we know while working from the inside out, the TEXT function is used to extract a weekday value from each given date.
It should be noted that the MAX function automatically ignores FALSE values and returns the highest remaining value. So now you have learned how to get the maximum value in the given weekday in the given data range in the workbook in Microsoft Excel.