i see on the conditional formatting that there is a place to click and it
says highlight cell rules and then it says a date occurring
my problem is that the date occurring only goes up to a month but i need it
to go up to a year
is there a way i can do a year on this

if this is not possible can you please let me know