Wednesday, 25 October 2017
  0 Replies
  3.5K Visits
0
Votes
Undo
I am using this formula to calculate Itemized, Monthly and yearly expenditures, however, once I hit January 2018 it does not read my date because it is reflecting a calendar year, not my fiscal year of 7/1/17-6/30.18. I see where the Year is pulling from as 2017 how do I get it to calculate a 2 year time frame?

=SUMIFS(tblItemized[Check Amount],tblItemized[G/L Code],[@[G/L Code]],tblItemized[Invoice Date],">="&D$3,tblItemized[Invoice Date],"<="&D$4)+SUMIFS(tblOther[Check Amount],tblOther[G/L Code],[@[G/L Code]],tblOther[Date Check Request Initiated],">="&DATEVALUE(tblMonthly[[#Headers],[January]]&" 1, "&_YEAR),tblOther[Date Check Request Initiated],"<="&D$4)
There are no replies made for this post yet.