Calculating a Date in SharePoint

Published On: Nov 16, 2010 1:47:47 PM

I need to calculate a date in SharePoint (e.g. adding seven days to a start date in order to get the due date), and if the start date is blank, then the calculated field is showing a date in the 1900s. How can I fix this issue?

You need to use the ISBLANK function for this plan to work. Here's an example:

=IF(ISBLANK([Start Date]),"00/00/00",( [Start Date]+7))

If the Start Date is blank, then the calculated field will be populated with 00/00/00. If it isn’t blank, then it will be the start date plus seven days.

Construction Management

About VPO

VPO is a cloud-based collaboration platform built just for construction project teams. Easily configurable and user-friendly, VPO is designed to enhance efficiency and productivity while minimizing risk. We partner with each customer to meet their team's unique project management needs. VPO is a certified Woman-owned Business Enterprise (WBE), and we've been improving construction project management through tech since 1984. In a world of start-ups, we're a stay-up.

GET STARTED