Forum Discussion
Function days360 with current date
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
Thank you Interkoubess
It is working the way I wanted. Just had to switch the column from date -> whole number in modeling.
The same as the data above. But than with EFD in the past
Company Margin Estimated first delivery (EFD) | days till EFD Ranking
Company A 10000 11-Feb-2018 | 31 322,5806
Company B 15000 13-jan-2018 | 3 5000
Company C 12000 12-Dec-2017 | -29 -413,793
Company D 9000 02-Jan-2018 | -8 -1125
In stead of heaving a - ranking I might even prefer to have a 0 valeu. But I assume this can be easaly done by IF(
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
Thank you Interkoubess
It is working the way I wanted. Just had to switch the column from date -> whole number in modeling.