If, ISBLANK, Date Difference combined calculated column

%3CLINGO-SUB%20id%3D%22lingo-sub-1708024%22%20slang%3D%22en-US%22%3EIf%2C%20ISBLANK%2C%20Date%20Difference%20combined%20calculated%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1708024%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20create%20a%20calculated%20Column%20in%20my%20SharePoint%20List%20based%20on%20following%20conditions%2C%20all%20are%20date%20columns%3A%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20Process%20Date%20ECR%20cell%20is%20blank%20then%20Today%20-%20Start%20Date%3CBR%20%2F%3EIf%20Process%20Date%20ECR%20cell%20is%20not%20blank%20then%20Process%20Date%20ECR%20-%20Start%20Date%3CBR%20%2F%3E%3CBR%20%2F%3EI%20used%20following%20formula%20but%20failed%2C%20can%20you%20please%20help%20me%20out%3CBR%20%2F%3E%3CBR%20%2F%3E%3DIF(ISBLANK(%5BProcess%20Date%20ECR%5D)%2C%20%5BToday%5D%20-%20%5BStart%20Date%5D%2C%20%5BProcess%20Date%20ECR%5D%20-%26nbsp%3B%5BStart%20Date%5D)%3CBR%20%2F%3E%3CBR%20%2F%3EToday%20is%20a%20column%2C%20which%20updates%20daily%20displaying%20Today's%20date.%3CBR%20%2F%3E%3CBR%20%2F%3Eit%20doesn't%20work%2C%20can%20you%20please%20help%20me%20out.%20It%20is%20very%20very%20important%20for%20me.%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%2C%3CBR%20%2F%3EAkash.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1708024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hello,

I want to create a calculated Column in my SharePoint List based on following conditions, all are date columns:

If Process Date ECR cell is blank then Today - Start Date
If Process Date ECR cell is not blank then Process Date ECR - Start Date

I used following formula but failed, can you please help me out

=IF(ISBLANK([Process Date ECR]), [Today] - [Start Date], [Process Date ECR] - [Start Date])

Today is a column, which updates daily displaying Today's date.

it doesn't work, can you please help me out. It is very very important for me.

Kind regards,
Akash.

0 Replies