I have a problem that I cannot seem to figure out.

I have data in column A1 and B1 I also have a date in column G1

What I need to be able to determine is, if the date falls within particular month, then the data from columns A1 and B1 need to be added together and put into the corresponding month column. The months Jan - Dec are in sep columns on the right from T1 thru AE1. I tried to use a simple IF statement to see if it could determine if the date was between the beginning and end of the month but I have either done something wrong in the formula or dates don't work with IF statements.

I used in the January column =if(G1<Jan1,if(G1>Jan31,(+a1+b1),""),"")
I changed the dates to Feb for the Feb column and so on.... The date in the G1 column did not matter if it was between or outside the dates for the month, the formula just returned an empty cell.


Any help would be appreciated.