Create a new calculated column with the formula:
=IF(OR(ISBLANK([Start Date]), ISBLANK([End Date])),"",DATEDIF([Start Date],[End Date],"d"))
The outcome will be the number of days difference for [End Date] -[Start Date]
=IF(OR(ISBLANK([Start Date]), ISBLANK([End Date])),"",DATEDIF([Start Date],[End Date],"d"))
The outcome will be the number of days difference for [End Date] -[Start Date]
No comments:
Post a Comment