I’m trying to make an If statement that shows true when the start and end date columns are within that range, but I can’t get it to work. Before I go and make a complicated formula, I wanted to see if I could get a simple formula to work. So, I made the formula: “Today() < {End}”. No matter what I do, I cannot get the correct dates to show as True. Thoughts?
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
IF Formula Not Working for Dates | 2 | 640 | February 26, 2024 | |
If date is blank, do this. If date isn't blank, do this | 2 | 2530 | January 31, 2023 | |
Function to Display a number when today's date is between 2 dates and the status is something | 1 | 20 | October 1, 2024 | |
IF function based on status column, calculate date | 4 | 1302 | March 22, 2023 | |
Compare Dates in an If Statement (Calculating offset quarter) | 7 | 5095 | June 25, 2024 |