Im using 3 columns that have formulas
G has =EDATE(F3,12)
H has =G3-TODAY()
I has =IF(H3<0,"EXPIRED",IF(H3<30,"EXPIRING SOON"))
So when I put in a date in F it puts in the information I need. The problem is when I drag the formula down it shows all the information. i ONLY WANT THE INFORMATION TO SHOW WHEN I ENTER THE DATE IN COLUMN f. ANY HELP WOULD BE APPRECIATED.
G has =EDATE(F3,12)
H has =G3-TODAY()
I has =IF(H3<0,"EXPIRED",IF(H3<30,"EXPIRING SOON"))
So when I put in a date in F it puts in the information I need. The problem is when I drag the formula down it shows all the information. i ONLY WANT THE INFORMATION TO SHOW WHEN I ENTER THE DATE IN COLUMN f. ANY HELP WOULD BE APPRECIATED.