I am at the end of the financial year again and setting up Excel spreadsheets. I am using a sumifs formula that looks at the date and sums one of the columns if the dates are between certain values. ie add up the values in the Bank Expenses column of all those entries dated between between 1st and 30th April.

My problem is that I need to change the formulae individually each year and it takes a long time! I have tried changing one and copying in various forms but they are complex formulae and it does not work correctly - I have been advised on another site that it is a common problem. If I could set them up so that it just used day and month then the problem would be solved but I know that Excel converts the date to a number to calculate.

I cannot see how to do this using the date as a text column. Does anyone have any ideas.

For complete info., the formula I am using is...

=SUMIFS($E$23:$E$1000,$A$23:$A$1000,">=01/04/2017",$A$23:$A$1000,"<=30/4/2017")

Thanks for any help