Thread: [Solved] How to enter dates between ? and ? in the criteria section of a database?
View Single Post
 
Old 07-01-2022, 07:26 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Code:
=SUMIFS(SumRange,OrderDateRange,">=" & DATE(2014,10,18), OrderDateRange, "<=" & Date(2015,10,17))
NB! SumRange and OrderDateRange must be of same dimension, i.e. must have same number of rows!
Reply With Quote