Forum Discussion
Solved
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...
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)
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)
- Thanks Rob- that solved it. Really appreciate your help.
