I have tried everything, can someone help me with this?
=IF(ISBLANK([Date1]),DATEDIF([Created],[Date2],"d"),IF(NOT(ISBLANK([Date1),DATEDIF([Date1],[Date2],"d"))))
It keeps saying unsupported syntax in SharePoint.
Add a comment
|
2 Answers
Try this:
=IF(ISBLANK([Date1]),DATEDIF([Created],[Date2],"d"),DATEDIF([Date1],[Date2],"d"))
Try this formula:
=IF(ISBLANK([Date1]), DATEDIF([Created], [Date2], "d"), IF(NOT(ISBLANK([Date1)), DATEDIF([Date1], [Date2], "d"), ""))
OR
=IF(ISBLANK([Date1]), DATEDIF([Created], [Date2], "d"), DATEDIF([Date1], [Date2], "d"))
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
answered May 13, 2021 at 3:17
Ganesh Sanap - MVP
47.4k22 gold badges32 silver badges64 bronze badges