Forum Discussion

PLove59's avatar
PLove59
Brass Contributor
Jun 18, 2021
Solved

Formula for SPO Calculated Column

Hello All, I need to revise the following Excel formula, =DAYS(F18,TODAY()) / 365 * 12 * 4000 for a SPO list's Calculated Column.  I'm using a Date/Time column [Shipout] to calculate the cost for a ...
Lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Jun 18, 2021

    PLove59 Try using below formula: 

     

     

    =DATEDIF([Shipout], Today(), "d") / 365 * 12 * 4000

     

     

    Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap's avatar
ganeshsanap
MVP
Jun 18, 2021

PLove59 Try using below formula: 

 

 

=DATEDIF([Shipout], Today(), "d") / 365 * 12 * 4000

 

 

Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • PLove59's avatar
    PLove59
    Brass Contributor
    Jun 18, 2021
    ganeshsanap Your formula worked perfectly ... thank you so much!

Resources