Calculated column showing number of days between dates

Copper Contributor


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. Any ideas?



4 Replies

@Tonje Waasjø you can use the DATEDIF function =DATEDIF(TODAY(),Expiry,"D")






Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)




Thank you for your answer Rob. When I paste this in, I get a syntax error message. I just change the name of the column. =DATEDIF(TODAY(),Sluttdato,"D")

@Tonje Waasjø 
go for this:

it will give you overdue days in negative days.
it will give you the overdue days in days.

This on worked for me.
Shows the number of day left for column date.