Adding # of days with in a date range
this is what i came up with looking at other people i keep getting #invalid operation
=SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1} <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1))
the first range (range 18) is the #number of event days in a month, the second (range 1) is the initial day of the event. I want to add up the days per month per event.
Best Answer
-
Looks to me like you're just missing a command in your SUMIFS formula before the <=. This should work
=SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1}, <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1))
Answers
-
Looks to me like you're just missing a command in your SUMIFS formula before the <=. This should work
=SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1}, <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1))
-
Thank you!
-
No problem, glad it's working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!