Datedif funcation error on Negative Values

[skorpion]

im trying to get the value that how many year month and days remaining and i used datediff but problem is when end date is greater then start date its giving me error

here is the formula

=DATEDIF(DATEDIF(today(),U2,"ym") &" months," &DATEDIF(today(),U2,"md") &" days"

so when its negative i need same output

and noe know how can i get rid this error

 

[pecoflyer]

when end date is greater then start date its giving me error

In this case the returned value should be positive? Which error do you get?
The DATEDIF syntax is DATEDIF(start_date,end_date,...
Please post a sample sheet

 

[skorpion]

no most of dates are negative as well and thn i got #NUM! error tis is the what i output i want is -1 month and -1 day

Function DATEDIF parameter 1 (2020/09/20) should be on or before Function DATEDIF parameter 2 (2020/08/19)

 

[skorpion]

I sort it out myself

=datedif(if(today() < T14, today(),T14),IF(today()>T14,today(),T14),"ym") & if(datedif(if(today() > T14, today(),T14),IF(today()>T14,today(),T14),"ym")=1,"Dayes"," شهر- ")&datedif(if(today() < T14, today(),T14),IF(today()>T14,today(),T14),"md") & if(datedif(if(today() > T14, today(),T14),IF(today()>T14,today(),T14),"md")=1,"Dayes"," يوم ")



BUT when dates are negative uts must so me neagtive values

 

[vletm]

skorpion
Is this almost same Your previous thread? ... even duplicate?

Datedif giving #Value Error

I have Excel where im using hijri dates and want to know th differnece betwwen two dates i used datedif funcaton bit geeting #Value error please some one can help me out on this

chandoo.org

 

[pecoflyer]

What are negative dates???

 

[IDidNotDoIt]

Days since pandemic started?

 

[p45cal]

BUT when dates are negative uts must so me neagtive values

=IF(TODAY()>T14,"-","") & DATEDIF(MIN(TODAY(), T14), MAX(TODAY(), T14),"ym") &
IF(DATEDIF(MIN(TODAY(), T14),MAX(TODAY(), T14),"ym")=1,"Dayes"," شهر- ")&
DATEDIF(MIN(TODAY(), T14),MAX(TODAY(), T14),"md") &
IF(DATEDIF(MIN(TODAY(), T14),MAX(TODAY(), T14),"md")=1,"Dayes"," يوم ")