Forum Discussion
Calculated column showing number of days between dates
Hi, I want a column that shows the number of days between a date thats in another field and todays date. I tried with this =floor((Number([Datefield])-Number(@now))/(1000*60*60*24)), but it failed. ...
Tonje Waasjø you can use the DATEDIF function =DATEDIF(TODAY(),Expiry,"D")
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)