For the passed few hours I have been racking my brains to the point it hurts and am doubting whether or not this can be done, although I am sure it can.

I think I am looking at a series of if/and/or functions?

I have a spreadsheet that is has a start date(A1), 3 month date(b1),6 month date (c2), and 12 month date(d2)

I am looking to have a formula that will apply a 1,2,3,or 4 to cell E2 dependent on the time frame.

If today's date is less than the 3 month date = 1
If today's date is greater than 3 month date but less than 6 month date = 2
if today's date is greater than 6 month date but less than 12 month date = 3
If todays date is greater than 12 month date = 4

I think I have the individual formula sorted, which I have put below but I am baffled as to how I can link these all together?

=today()<A1 = 1
=if(and(today()>A1,today()<B1,2,"")
=if(and(today()>c1,today()<d1,3,"")
=today()>f1=4

If anyone can help with this at all it would be greatly appreciated, my head is bursting trying to solve this!