Calculated Column when blank

%3CLINGO-SUB%20id%3D%22lingo-sub-716159%22%20slang%3D%22en-US%22%3ECalculated%20Column%20when%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716159%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%202%20columns.%20Date%20A%20and%20Date%20B.%20I%20have%20a%20calculated%20column%20that%20works%20out%20if%20Date%20A%20will%20expire%20in%2030%20days%20from%20today%20and%20marks%20a%20Status%20Column%20as%20expired%20or%20not%20expired.%20I%20now%20want%20to%20add%20a%20second%20formula%20for%20Date%20B.%20So%20my%20calculated%20Status%20column%20will%20show%20expired%20if%20Date%20A%20or%20Date%20B%20will%20expire%20in%2030%20days.%20The%20complicated%20bit%20is%20Date%20A%20or%20Date%20B%20could%20contain%20no%20value%20at%20all.%20How%20do%20I%20get%20a%20calculated%20Status%20column%20to%20work%20with%20two%20Dates%20and%20possible%20null%20values.%20The%20formula%20I%20have%20so%20far%20is%20as%20follows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%5BDate%20A%5D-30%26lt%3B%3DNOW()%2C%22Expired%22%2C%22Not%20Expired%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-716159%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

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")

0 Replies