Hey guys, im an absolute n00b at scripting and coding, so im wondering if this is possible in an excel sheet at a basic level;

I have a list of say 200+ Servers with the manufacturer warranty expiry dates of all sorts (expired, and expiring, etc) on another column

I want a column where it looks at say CELL1 - TODAY and then either sends me an email when its 30 days short of today (i.e expires in 30days)

is it possible?