How to enter dates between ? and ? in the criteria section of a database?

		Microsoft Office Forums > Microsoft Excel > Excel
How to enter dates between ? and ? in the criteria section of a database?

07-01-2022, 07:26 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to enter 'Page 1' from the footer menu in the right hand section, and not the middle section?	Jules90	Excel	2	08-11-2021 06:44 AM
How to filter between two dates in MS Query criteria when the dates are text ("20180903", etc.)	kingmb	Excel	2	09-11-2018 01:08 AM
Create a unique list of values that match a criteria, sorted in order of another criteria	BradRichardson	Excel	2	01-03-2017 12:25 AM
Why do you need to enter your password twice when connecting to an SQL Server database?	Dedication99	Mail Merge	0	08-05-2016 02:18 AM
Is there a way to detect duplicate dates as I enter them?	Karin	Excel	1	03-04-2011 12:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 PM.