If Then Using Todays Date +/- 30 Days

[1313]

Hi - I am trying to create a formula that states the following:

If date in cell K3 is less than 30 days from today's date (I can put today's date in cell A3 if needed), then cell M3 = Yes

I cannot figure this one out... can anyone help?

THANK YOU!!!!

 

[wigi]

=if(K3-today()<30,"yes","no")

 

[1313]

THANK YOU!!!

One more question.... as I am creating a list that will be populated as items come up, the cells in K will be blank (of course, until a date is entered). However, when I populate the M column cells with the formula you provided, the all say "yes".

Is there a way to have them blank, until the K column cells are populated?

thanks again.... priceless information for me!!

 

[wigi]

=if(K3="","",if(K3-today()<30,"yes","no"))

Browsing the board for similar topics will yield very usesful information.