Skip to main content
Topics#Data ManagementDomanda di Jeremy Malander
Jeremy Malander ha fatto una domanda in #Data Management
24 apr 2013, 21:59

Formula Rule: How many days until... 2016

IF( MONTH(CloseDate)=12, DATE(YEAR(CloseDate),12,31) - CloseDate, DATE(YEAR(CloseDate), MONTH(CloseDate)+1,1) - CloseDate-1)

 

This is pulled from formula examples from Help & Training...  It calculates the number of days until a specific date.  However.. if the date is in a future year, this formula doesnt work.  Any ideas?

 

Thanks!
4 risposte
  1. Steve Molis (You Owe Me a Beer, Inc.)
    24 apr 2013, 23:49
    Here you go:

     

    Datatype = Formula

     

    Result = Number

     

    Formula =  DATE(2016, 01, 01) - TODAY() 
Scrivi una risposta...
0/9000