Forum Discussion

Tonje Waasjø's avatar
Tonje Waasjø
Copper Contributor
Nov 17, 2021

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

 

 

Lists
SharePoint Online

4 Replies

Sort By
  • Mathias_Stark's avatar
    Mathias_Stark
    Copper Contributor
    Jan 22, 2024
    This on worked for me.
    =TODAY()-Slutdatum
    Shows the number of day left for column date.
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Nov 17, 2021

    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)

     

     

     

    • Tonje Waasjø's avatar
      Tonje Waasjø
      Copper Contributor
      Nov 17, 2021
      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")
      • coreYalex's avatar
        coreYalex
        Copper Contributor
        Jul 02, 2023

        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.

Resources