In my case i have a range for a given month on a spreadsheet and I want a
tally of timely received applications indicated on a summary spreadsheet, the
application is timely if the date received is between the 1st and the 15th of
the given month, will this formula subbing out the dates each month work?
Right now I am waiting until the 16th of each month to enter the number of
applications received manually and I want to automate the process.
That would work fine, substituting your dates in the formula.
You could also enter the date for the month that you require in a cell e.g.
in C1 enter 01 May 2008, and with your dates in column A of Sheet1, then
=SUMPRODUCT((MONTH($A$1:$A$1000)=MONTH($C$1))*(DAY($A$1:$A$1000)<16)*($A$1:$A$1000)<>""))
Change the ranges to suit.
You only need to alter the Date in C1 when you want the figures for another
Month
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.