Date after Due Date

[ozbeachbum]

Hi,
I am using the following formula to calculate the amount of time left before a due date, showing the number of Years - Months - Days.
=DATEDIF(QO4,Jun!EU129,"Y") & " - " & DATEDIF(QO4,Jun!EU129,"YM") & " - " & DATEDIF(QO4,Jun!EU129,"MD")& " "
(Sheet Check) QO4 being TODAYS DATE and (Sheet Jun) Jun!EU being the DUE DATE, result is located on (Sheet Check).
Once the due date is past the formula returns #NUM!. I would like that once the due date is past if the result showed ZERO Y's - M's - D's.

On another note if you would also include a formula, where once the due date is passed the result will show the number Years - Months -Days overdue, it would be greatly appreciated.

Thanking you in anticipation.
Dave.

 

[bebo021999]

Try with 2 opttions:
Option 1: for over due like this : "Over due 1-0-1"

=IFERROR(DATEDIF(QO4,Jun!EU129,"Y")&" - "&DATEDIF(QO4,Jun!EU129,"ym")&" - "&DATEDIF(QO4,Jun!EU129,"md"),"Over due "& DATEDIF(Jun!EU129,QO4,"Y")&" - "&DATEDIF(Jun!EU129,QO4,"ym")&" - "&DATEDIF(Jun!EU129,QO4,"md"))

Option 1: for over due like this : (1)-(0)-(1)

=IFERROR(DATEDIF(QO4,Jun!EU129,"Y")&" - "&DATEDIF(QO4,Jun!EU129,"ym")&" - "&DATEDIF(QO4,Jun!EU129,"md"),"("& DATEDIF(Jun!EU129,QO4,"Y")&") - ("&DATEDIF(Jun!EU129,QO4,"ym")&" )- ("&DATEDIF(Jun!EU129,QO4,"md")&")")

 

[ozbeachbum]

Try with 2 opttions:
Option 1: for over due like this : "Over due 1-0-1"

=IFERROR(DATEDIF(QO4,Jun!EU129,"Y")&" - "&DATEDIF(QO4,Jun!EU129,"ym")&" - "&DATEDIF(QO4,Jun!EU129,"md"),"Over due "& DATEDIF(Jun!EU129,QO4,"Y")&" - "&DATEDIF(Jun!EU129,QO4,"ym")&" - "&DATEDIF(Jun!EU129,QO4,"md"))

Option 1: for over due like this : (1)-(0)-(1)

=IFERROR(DATEDIF(QO4,Jun!EU129,"Y")&" - "&DATEDIF(QO4,Jun!EU129,"ym")&" - "&DATEDIF(QO4,Jun!EU129,"md"),"("& DATEDIF(Jun!EU129,QO4,"Y")&") - ("&DATEDIF(Jun!EU129,QO4,"ym")&" )- ("&DATEDIF(Jun!EU129,QO4,"md")&")")

Thanks so much.
Worked fine.
Dave.