Dé Céadaoin, 25 Deireadh Fómhair 2017
  0 Freagraí
  Cuairteanna 3.4K
0
Vótaí
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)
Níl aon fhreagraí déanta don phost seo go fóill.