Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Days Remaining Calculation

I am looking for some help calculating days remaining.     That is to say that I have a specific field which identifies an "end date", and I am looking to calculate how many days between today and ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Awesome.  Actually needed a MIN not MAX, as I was trying to get a day count between today and end date.  If end date is after today then 0.

     

    = MIN ( 1 * ( Today ( ) - YourTable[EndDate] ) , 0)

     

    Thanks - this was extremely helpful!

  • Datatouille's avatar
    Datatouille
    9 years ago

    Anonymous

     

    If [End Date] > Today ( ) Then 0 Else 1 * ( Today ( ) - YourTable[EndDate] ) is equivalent to

     

    MAX ( 1 * ( Today ( ) - YourTable[EndDate] ) , 0)

     or

    - MIN ( 1 * (  YourTable[EndDate] - Today ( )  ) , 0 )

     

    But not to:

    MIN ( 1 * ( Today ( ) - YourTable[EndDate] ) , 0)

Datatouille's avatar
Datatouille
Solution Sage
9 years ago

Anonymous

 

Ok try this one which is more universal and covers the cases when your EndDate is superior to Today

 

= 1 * ( Today() - YourTable[EndDate] )

 

You can make the result absolute with Abs( ) if necessary.

 

If it solves your problem, please accept as a solution so everyone can benefit from our discussion !

Anonymous's avatar
Anonymous
Not applicable
9 years ago

OK Excel side.  We're getting warmer, and this is awesome.  However, using this solution when the end date is before today, it essentially begins couting days since the end date which ideally for my report would be 0.

 

i.e. if end date > today, then 0

 

Not sure how to incorporate that into your recommendation.

 

Thanks in advance.