Calculated value for difference between two dates, with IF qualifier

Hi all, First time user of the forum and not a Lists expert, so please forgive any errors. See screenshot for example. I have a column in a list that calculates the value between two da tes to...

microsoft lists

Rob_Elliott
Mar 03, 2024
MeganTPT You could use a formula like

=IF(ISBLANK(End),"",(DATEDIF(Start,End,"D")))

which results in:

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Forum Discussion

Calculated value for difference between two dates, with IF qualifier

Resources