Countifs plus a date range?
My sheet has a column with due dates across the year. I would like to count how many are due each month for a forecast report to show # due in Jan, # due in Feb, etc.
How do I write the formula for the date so that it includes all days of each month?
=Countifs [Adjusted Due date]:[Adjusted Due Date], DATE>=Jan1,[Adjusted Due date]:[Adjusted Due Date], DATE<=Jan31
Thank you for your time and help.
Help Article Resources
Check out the Formula Handbook template!