=BDATE (Between Dates)
The BDATE function compares a date to determine whether it falls between two other dates.
Syntax
Section titled “Syntax”=BDATE(IsThisDate; GreaterThanThisDate; AndLessThanThisDate)Parameters
Section titled “Parameters”-
IsThisDate
- The date being evaluated.
-
GreaterThanThisDate
- The start date that IsThisDate must be greater than.
-
AndLessThanThisDate
- The end date that IsThisDate must be less than.
How It Works
Section titled “How It Works”-
The function checks whether IsThisDate is greater than the first comparison date and less than the second comparison date.
-
If the condition is met, the function returns 1 (true).
-
If the condition is not met, the function returns 0 (false).
Usage Notes
Section titled “Usage Notes”-
Dates must be provided in a valid date format.
-
Both comparison conditions must be true for the function to return 1.
-
This function is commonly used in conditional logic and date-based workflows.
Example
Section titled “Example”=BDATE(2023-04-23; 2023-04-20; 2023-04-28)Returns: 1 (true)
Keywords
Section titled “Keywords”BDATE, date comparison, between dates, date range check, formula function, conditional logic, workflow formulas, date validation