Walker_Ice
Board Regular
- Joined
- Oct 6, 2023
- Messages
- 50
- Office Version
- 2021
- Platform
- MacOS
Hi Everyone,
I"ve been trying to figure out how to do this and been stuck for over a week. I created this custom report table, which works great. But the problem, I'm having is if I enter a "Start Date" which has a different year then my "End Year". It doesn't include the data from the different months in between the start year and end year.
For example, If I select 6/1/2023 until 9/30/2023. I gives me the correct data for those months because they are also in the same year.
But if I select 6/1/2022 until 9/30/2023, the formula I came up with doesn't know that it needs to get the data for all the months in between those dates because they are from different years.
I think I need an If statement, to resolve the problem. But I'm not sure. Can someone please take a look and help if possible? Below is the formula I am using with the SUMIFS function.
Thank you, in advance.
=SUMIFS(Income_TotalPay,Income_Dates,">="&DATE(K28,MONTH($L$25),DAY($L$25)),Income_Dates,"<="&DATE(K28,MONTH($N$25),DAY($N$25)))
I"ve been trying to figure out how to do this and been stuck for over a week. I created this custom report table, which works great. But the problem, I'm having is if I enter a "Start Date" which has a different year then my "End Year". It doesn't include the data from the different months in between the start year and end year.
For example, If I select 6/1/2023 until 9/30/2023. I gives me the correct data for those months because they are also in the same year.
But if I select 6/1/2022 until 9/30/2023, the formula I came up with doesn't know that it needs to get the data for all the months in between those dates because they are from different years.
I think I need an If statement, to resolve the problem. But I'm not sure. Can someone please take a look and help if possible? Below is the formula I am using with the SUMIFS function.
Thank you, in advance.
=SUMIFS(Income_TotalPay,Income_Dates,">="&DATE(K28,MONTH($L$25),DAY($L$25)),Income_Dates,"<="&DATE(K28,MONTH($N$25),DAY($N$25)))