Note: The other languages of the website are Google-translated. Back to English
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
  1.6K Visits
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.

Follow Us

Copyright © 2009 - | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL