Got any Excel/VBA Questions? Free Excel Help
To count dates that fall between a date range we can use SUMPRODUCT with a twist. Suppose you have a list of valid dates in A1:A20. The formula we can use to count dates that fall between 2 dates is:
Where D1 houses your start date and E1 you end date.
Or, we can hard code the dates into our SUMPRODUCT Function by using the DATE Function.
Syntax for the date function is: DATE(Year, Month, Day)
|Convert Dates To Excel Formatted Dates|
|Convert Excel Formula/Functions to Values|
|Converting Numbers Seen Text By Excel to Real Numbers|
|Convert Excel Dates/Time to True Dates & Times|
|Copy, Cut & Paste Special in Excel|
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.