SharePoint calculated column blank date [Two Examples]

Assume that you have a SharePoint list date column, and some of the items of it are blank dates, but you need to create a calculated column based on that.

So in this SharePoint tutorial, I will show you how to create a SharePoint calculated column blank date in the SharePoint list with two scenarios.

In two scenarios, I will demonstrate how to create a SharePoint calculated column blank date using a single date column and also with the two date columns in the SharePoint list.

Scenario 1: Create a SharePoint calculated column blank date using a single date column in the SharePoint list

With an example, let me explain, I have a SharePoint List (Order Details), which has an Estimated Date column (Date and time type).

I will create a calculated column (Order Status) based on that column, using the if statement. If the estimated date column is blank, it provides the order status as “Delivered” or “Product will deliver in 2/3 days“.

Now we will see how to achieve it:

• Open the SharePoint list, where you must create a calculated blank date using a single date column.
• Now click on the +Add column -> choose See all column types -> Then click on the Next button.

• In Create column page, provide the column name and choose the type as Calculated (calculation based on other columns) as shown below:

• Now provide the formula in the formula box using the if statement. Based on my requirement, I provided the formula as shown below:

=IF(ISBLANK([Estimated Date]),"Delivered","Product will deliver in 2/3 days")

• The data type returned from this formula is: Choose the data type, as “Single line of text”.
• Then, click on the OK button.

• Now open your SharePoint list, the calculated column will be added as Order Status.

This is how we can create a SharePoint calculated column blank date using a single date column in the SharePoint list.

Scenario 2: Create a SharePoint calculated column blank date using two date columns in the SharePoint list

With an example, let me explain, I have a SharePoint List (Product Issue Tracker), which has a two date column, such as:

1. Issue Start Date
2. Issue Resolved Date

Now based on that column, I will create a calculated column (Issue Resolved or what) using the if statement.

• If the Issue Start Date column is blank, then it provides “N/A”
• If the Issue Resolved Date is greater than or equal to Issue Start Date, then it provides the Issue resolved or what as “Yes” or else “No“.

Now we will see how to achieve it:

• Open the SharePoint list, where you want to create a calculated column blank date using a single date column.
• Now click on the +Add column -> choose See all column types -> Then click on the Next button.

In Create column page, provide the column name and choose the type as Calculated (calculation based on other columns) as shown below:

• Now provide the formula in the formula box using the if statement. Based on my requirement, I provided the formula as shown below:

=IF(ISBLANK([Issue Start Date]),"N/A",IF([Issue Resolved Date]>=[Issue Start Date],"YES","NO"))

• The data type returned from this formula is: Choose the data type as a Single line of text.
• Then, click on the OK button.

• Now open your SharePoint list, the calculated column will be added as Issue Resolved or what.

This is how to create a SharePoint calculated column blank date using a two-date column in the SharePoint list.

Conclusion

Here, I have shown you two scenarios of creating a SharePoint calculated column blank date using a single date column using the list in SharePoint Online.

Moreover, in 2nd scenario, I have explained how to create a SharePoint calculated column blank date, if a condition is not met with the two date columns in the SharePoint list.

You may also like:

• SharePoint Calculated Column If Statement
• SharePoint calculated column random number
• SharePoint calculated column get month from date
• SharePoint Calculated Column Concatenate Function