ozbeachbum
Board Regular
- Joined
- Jun 3, 2015
- Messages
- 159
- Office Version
- 2021
- Platform
- Windows
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.
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.