How to Use Date Difference As Criteria in DSUM in Google Sheets

0
247
DSUM date as criteria

I’ve recently written a detailed tutorial about the use of DSUM in Google Sheets. Now in this tutorial I will explain you how to use date difference as Criteria in DSUM. Date has to be used in a particular format in order to work it as criterion in DSUM or in any other functions.

This post is exclusively for the use of date as criteria in DSUM. Why I’m specific to this point is that there is difference in the date format when we use it in functions like QUERY. There you should follow the Long-winded Approach to convert date to text. Other wise you may face errors in your collaborated Spreadsheet.

Again I’m specific to DATE DIFFERENCE AS CRITERIA. Do you know why? Because when you want to find data based on a particular date as criteria, you can directly use the date. But if you want DSUM to check the given range for data that falls between given two dates then there is a different approach. That is what we are discussing in this Google Sheets tutorial.

Steps to Use Date Difference As Criteria in DSUM in Google Sheets

The date format is as below.

=date(yyyy,mm,dd)

When you use DSUM criteria between two dates there you should use the “>” and “<” symbol. Then the date format should be as follows.

=”>”&date(yyyy,dd,mm)

How to Use Date Difference As Criteria in DSUM – Example

The DSUM example below uses multiple date criteria.

Date Difference As Criteria in DSUM

See the criteria fields on the top where you can see I’ve used multiple date criterion in DSUM. I’ve used the “Ctrl+~” sign to show you the formula in the field. In real case the date will look like differently. Check Cell C3 where the date format I applied is-

=”>=”&date(2017,7,1)

multiple dates in criteria in DSUM formula

Hope you understood.

Note: The above “Ctrl+~” shortcut key is helpful when you want to copy content between Excel and Google Sheets retaining the formula, not formula results. Use the comment section to share your views.

Conclusion

You can only explore the possibility DSUM function offers by effectively using Criterion. So try with different criterion with your own sample data.

LEAVE A REPLY

Please enter your comment!
Please enter your name here