Sharepoint Calculated Column Question

Question

I want to apply two formulas to my calculated column but I can only get one or the other to work at a time. The first is to return a date two years from the date in the [Training Completed] column, and if there is no date in the [Training Completed] column return a blank value (or appear as a blank value).

The two formulas I have are:

=DATE(YEAR([Training Completed]) + 2, MONTH([Training Completed]), DAY([Training Completed])

and

=IF(ISBLANK( [Training Completed]), "",

They both work one at a time but I don't know how to get them to work together?

Answer 1

Hi Libby Macdonald,

You can combine both formulas into a single expression like this:

=IF(ISBLANK([Training Completed]), "", DATE(YEAR([Training Completed]) + 2, MONTH([Training Completed]), DAY([Training Completed])))

This formula checks if [Training Completed] is blank—if it is, it returns an empty string (""), making the calculated column appear blank. Otherwise, it calculates the date two years from the [Training Completed] date.

Let us know if it helps or if you need any further assistance!

Best Regards,
Community Moderator | Sophia