Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 25 October 2017
  0 Replies
  3.2K 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.