Check If A Date Falls In A Given Week In Excel

This post demonstrates how we could determine if a date falls in a given week.For planning purpose we are required to have such knowledge.

Let’s check in simple steps how we can check that a given date falls in a given week in excel.

Suppose we have a task start date, task end date and the week starting dates in columns and we are interested to have values as “Yes” or “No” depending on whether the task start and task end date falls under a given week as represented below.

The dates in row 2 are the week starting date.

Capture

Step 1




We will write a simple below formula using IF and OR function in excel.

=IF(OR(E$2<$B3,$C3<D$2),”No”,”Yes”)

D2 is the week starting date and E2 is the week ending date.

B2 is the task start date and C2 is the task end date.

Capture

Step 2

Now copy and paste the formula in the entire table as shown.




Capture

Hope this helped.

Share The Knowledge

Random Posts

  • ISBLANK Formula In Excel

    Let’s see how to check blank cell in excel. ISBLANK () formula in excel is used to check blank cell […]

    Share The Knowledge
  • Return Formula As String In Excel

    Let’s see how to return a formula as string or formula as text in excel. We often come across a […]

    Share The Knowledge
  • Create Rows From Column In Excel

    Create Rows From Column In Excel, transpose column into rows in excel, vba to create rows from column values, transform excel column values into row values, change column to row in excel

    Share The Knowledge
  • Count Cells Based On Font Color In Excel

    In this post we will see how we could count the cells with the same font color e.g. number of […]

    Share The Knowledge

Leave a Reply