Hopefully someone here can help me with a formula.
I have a workbook with two worksheets. One sheet "Data" holds the data which is the last date of every month for a 10 year period.
What I want to do is enter two dates on the "Calc" sheet and enter a formula in E5, of that sheet, to calculate how many of the dates on the "Calc" worksheet are between the two dates input. I hope this makes sense.
I have attached an example.
Bookmarks