IF/AND Formula not working for Date falling within a specific Month
Hi, I am struggling to get an IF/AND formula to work correctly, and hope someone can help me.
The formula is in a text/number column labeled "Oct". I need the formula to look at the date column labeled "Proposed Start Date" and the date column labeled "Proposed End Date". The proposed start date and proposed end date represent the duration of a project. I need to have the formula return the value in the text/number column labeled "Total Team" when the project will be active in Oct.
My formula is:
=IF(AND($[Proposed Start Date]@row <= DATE(2023, 10, 1), $[Proposed End Date]@row >= DATE(2023, 10, 31)), $[Total Team]8, "")
For example, the formula is working correctly for the duration data range of 06/26/23 through 04/12/23 (shown in the first row.) But it isn't for the range 10/16/23 through 05/17/24 and 10/30/23 through 01/26/24 (shown in the red boxed cells.)
Best Answer
-
Try swapping your arguments to be start date is less than or equal to the END of October and the end date is greater than or equal to the START of October.
Answers
-
Try swapping your arguments to be start date is less than or equal to the END of October and the end date is greater than or equal to the START of October.
-
Thank you Paul! That did the trick (and makes sense.) 🤣 I knew it was something I just kept reading over. I appreciate you helping me out.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!