Range of cells

[wendy21]

I have a range of cells d24:g24 that either have a date in them or are blank. I need to put a formula in h24 where the word Alert will appear if any of the dates are less than 180 days from today. Can anyone help?

 

[cunningAce]

<today()-180,"alert","do else")
Hi</today()-180,"alert","do>
​

<strike></strike>

 

[Fluff]

How about
=IF(MIN(D24:G24)< TODAY()-180,"Alert","")

 

[wendy21]

Thank you, got it working now

 

[Fluff]

Glad to hear it & thanks for the feedback