Wimpie
Board Regular
- Joined
- Aug 12, 2008
- Messages
- 210
Good day
Tried a few things already but not winning.
Will appreciate any help, even VBA
I have the following formula in C3 on a Sheet called Y_M_D :
=DATEDIF(A3,B3,"Y") & " Years, " & DATEDIF(A3,B3,"YM") & " Months, " & DATEDIF(A3,B3,"MD") & " Days"
I need the Years, Months, and Days to be in a different color from the numbers.
If this is what the formula produces
Regards
Tried a few things already but not winning.
Will appreciate any help, even VBA
I have the following formula in C3 on a Sheet called Y_M_D :
=DATEDIF(A3,B3,"Y") & " Years, " & DATEDIF(A3,B3,"YM") & " Months, " & DATEDIF(A3,B3,"MD") & " Days"
I need the Years, Months, and Days to be in a different color from the numbers.
If this is what the formula produces
14 Years, 11 Months, 27 Days |
Regards