Repeat formula not working

[SaraWitch]

Hello peeps,

I have a run of the same formula, calculating monthly spend, but the one for March is not working. I have checked the formula, the formatting (including conditional formatting) but cannot figure out why it's not working. I've attached a copy of the workbook and offending formula is on the 'RSI Activities Fund' sheet, cell N5:

RSI Activities Log.xlsm

Microsoft Excel Workbook

1drv.ms

Any advice would be greatly received!
Sara

 

[Fluff]

30/2/2022 is not a valid date

 

[SaraWitch]

Oh my goodness! I had changed it to 29/03/2022 too, and realised it wasn't a leap year; not sure how it reverted to 30/2 - good old typos!

For the second time in as many days - thank you, Fluff!

 

[Fluff]

My pleasure.