Finding the first date in a column given that comes after a given date

[Sweedler]

Hello

So I have a table in one tab that has a column of dates. On a separate sheet I have calculations that need to be carried out on a monthly basis, meaning that all the rows of dates of a given month need to be included. I am using a sum formula with an INDIRECT formula to incorporate varying row numbers. But I need a separate formula to help me find the row number for the first instance that the particular month appears and the last one (or the first one of the next month and then minus 1 from that row as all the dates are in order.

I hope that makes sense and that you can help me here.

 

[Snakehips]

@Sweedler Any reason why you cannot just use SUMIFS?

 

[Sweedler]

I suppose not, just tested it out and was very happy with my results.