=BEDATE (Between or Equal To Dates)
The BEDATE function compares a date to determine whether it falls between two other dates or is equal to either boundary date.
Syntax
Section titled “Syntax”=BEDATE(IsThisDate; GreaterThanOrEqualToThisDate; AndLessThanOrEqualToThisDate)Parameters
Section titled “Parameters”-
IsThisDate
- The date being evaluated.
-
GreaterThanOrEqualToThisDate
- The start date that IsThisDate must be greater than or equal to.
-
AndLessThanOrEqualToThisDate
- The end date that IsThisDate must be less than or equal to.
How It Works
Section titled “How It Works”-
The function checks whether IsThisDate is greater than or equal to the first comparison date and less than or equal to the second comparison date.
-
If both conditions are met, the function returns 1 (true).
-
If either condition is not met, the function returns 0 (false).
Usage Notes
Section titled “Usage Notes”-
Dates must be provided in a valid date format.
-
Boundary dates are included in the comparison.
-
This function is useful for inclusive date range checks in conditional logic and workflows.
Example
Section titled “Example”=BEDATE(2023-04-20; 2023-04-20; 2023-04-28)- Returns: 1 (true)
Keywords
Section titled “Keywords”BEDATE, inclusive date comparison, between or equal dates, date range check, formula function, conditional logic, workflow formulas, date validation