Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Function days360 with current date

I would like to create a column which counts the days from today till a certain date. And devide the margin by the number of days to create a certain ranking.     I will upload a table which cont...
Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi Anonymous,

     

    Please create a calculated column with the formula below I created a column with today value Tdate:

     

    =DATEVALUE([Estimated first delivery (EFD)])-DATEVALUE([Tdate])

    Let us know if it does not work.

     

    For your second request yes an if can resolve it.

     

    Ninter

  • Anonymous's avatar
    Anonymous
    8 years ago

    Thank you Interkoubess

    It is working the way I wanted. Just had to switch the column from date -> whole number in modeling.

     

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi Anonymous,

 

Please create a calculated column with the formula below I created a column with today value Tdate:

 

=DATEVALUE([Estimated first delivery (EFD)])-DATEVALUE([Tdate])

Let us know if it does not work.

 

For your second request yes an if can resolve it.

 

Ninter

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you Interkoubess

It is working the way I wanted. Just had to switch the column from date -> whole number in modeling.