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: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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