Ignore Months In The Future

Hi

I have a table with data entered in columns by month starting in April of each year. The data in each cell is referenced from elsewhere but, what I want to do is add a check in the formula of each cell to only add data in the columns for the months that have passed. So, in the attached worksheet all data would be populated except for the last column, March, which we haven't yet got data for as it's now on February (just). And it needs to be blank, not show zero as the data will be used in a line chart.

I am currently using =IF(MONTH(TODAY())>C$43,"",C34) where C34 is an example of the cell reference for the data but, where I've put "" to try and populate the cell with blank it's still returning a zero.

Not sure if I've explained this too well but any help would be appreciated.

Forgot to say, C$43 in the above post should read A$1 which is a reference to the month as in the attachment.

It is date formatted in my original spreadsheet, I just forgot to format it in the example attachment.

Thanks for those, they were helpful and work.

But, is there anyway I could accomplish this without having to enter the full date in Row A because I want to re-use this same worksheet from scratch on the first of April each year and, with the above I would have to go to each month and change them for the current year.