I have this formula that i need to improve:
=if(and(today()<(DATEVALUE(C2&"/"&C$1&"/"&$A2)-7);DATEVALUE(C2&"/"&C$1&"/"&$A2));"";"It Misses 7 Days")

This formula works, but to apply to every case i need to change it, these
are the db:
Jan Febr March ....
Year 12 Upper Formula
Year 6 Upper Formula
Changed
Year 5 Upper Formula
Changed

If anyone try this formula works but i need to change it manually in every
line.
I was trying to change where C2 is to a sum of that data in this case it
would give me 12, but i have a serius problem to get the month, represented
in formula by C1.
I've tryed to use Hlookup but once the month is upper i tryed to put in last
row of excel a copy of C1:, to give me back the month, but or i did something
wrong or is my knowledge.

Someone undearstand what i want? And can anyone help me?
Thanks