One month notification

[adam]

Hi anyone,

I'm using the following formula in google sheet to display text in column H if today exceeds the date in column G. The formula works fine in this manner.

However, I need to amend the formula so that it will also display text "1 month" if the expiry date is one month ahead. if the expiry date is not reached the formula will display the text "OK"

following is the formula I'm using.
=ARRAYFORMULA(IF(ROW(A1:A)=1,"EXPIRY",IF(G1:G="","",If(G:G>TODAY(),"OK","expired"))))

any help would be kindly appreciated.

[HansV]

=ARRAYFORMULA(IFS(ROW(A:A)=1,"EXPIRY",G:G="","",G:G<=TODAY(),"Expired",G:G<=EDATE(TODAY(),1),"1 Month",TRUE,"OK"))

[adam]

Thankyou so much for the help Hans. Sorry for the very late reply.