Hi, I have 2 columns. Date A and Date B. I have a calculated column that works out if Date A will expire in 30 days from today and marks a Status Column as expired or not expired. I now want to add a second formula for Date B. So my calculated Status column will show expired if Date A or Date B will expire in 30 days. The complicated bit is Date A or Date B could contain no value at all. How do I get a calculated Status column to work with two Dates and possible null values. The formula I have so far is as follows.
=IF([Date A]-30<=NOW(),"Expired","Not Expired")
