Calculated column showing number of days between dates

[Tonje Waasjø]

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

[#2]

@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)

[#3]

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")

[#4]

@Tonje Waasjø 
go for this:

=ReviewDate-today()
it will give you overdue days in negative days.
=(ReviewDate-today())*-1
it will give you the overdue days in days.

[#5]

This on worked for me.
=TODAY()-Slutdatum
Shows the number of day left for column date.