I would like to have a calculated column based producing dates from data in 3 other columns

First column is one of the following: Wave 1, Wave 2, Wave 3, Custom Dates

Second and Thrid Column are dates only for use when Custom Dates is selected to provide said dates.

I'd like to create a set caclulated colume that either: -produce a start/end date based on the wave selected. -Or produce the custom start end date provided in the second or third column.

Like this:

enter image description here

I was trying to figure out a way to use multiple IF conditions like:

=IF([Wave]="Wave 1", "1/1/18"), IF([Wave]="Wave 2", "2/1/18"), IF([Wave]="Custom Dates", "[Custom Start]")

But I couldn't get anything like that to work.

Thanks in advance!

1 Answer 1


Use below:

=IF(Wave="Wave 1","1/1/2018",IF(Wave="Wave 2","2/1/2018",[Second]))

and return type of the calculated column must be set to Date and Time

enter image description here

enter image description here

  • THANKS!!! Any idea why mine is producing a date of "12/30/1899" for my rows that have a Wave listed?
    – Jon H
    Mar 7, 2018 at 21:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.