DATEDIFF between two dates or if one date isn't given DATEDIFF between one date and today

[lynnzrae]

I am creating a new column to identify the cycle time for projects.

I want to create a formula so that I datediff from the start date to the complete date and if there is not a complete date (complete date is blank) I want to datediff from the start date to today.  Thank you for your help.

Project Start Date	Project Complete Date	Project Cycle Time
1/15/2024	1/31/2024
2/9/2024
3/5/2024	6/1/2024
1/16/2024	2/27/2024
6/5/2024

[lynnzrae]

Perfect, thank you.

[BeaBF · Accepted solution]

@lynnzrae Here the calculated column:

Project Cycle Time_BBF =

IF(

    ISBLANK('Table'[Project Complete Date]),

    DATEDIFF('Table'[Project Start Date], TODAY(), DAY),

    DATEDIFF('Table'[Project Start Date], 'Table'[Project Complete Date], DAY)

)

output:

BBF