Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Sorting years,months,days Formula result
0 views
Skip to first unread message
Wanda Dale
Jun 22, 2001, 1:59:00 AM6/22/01
to
Is there a way to "double-digit" the results of a Date Calculation formula?
When I sort the 100 items in the column, there is a problem with recognizing
10 from 1. Eample: 1 year, 0 months, 10 days sorts before 1 year, 0 months,
1 day. This holds true for the month numbers as well. Any solutions.
This is the formula I'm using to get the difference between two dates:
=DATEDIF(B539,A539,"y")&" years, "&DATEDIF(B539,A539,"ym")&" months,
"&DATEDIF(B539,A539,"md")&" days"
When I sort the 100 items in the column, there is a problem with recognizing
10 from 1. Eample: 1 year, 0 months, 10 days sorts before 1 year, 0 months,
1 day. This holds true for the month numbers as well. Any solutions.
This is the formula I'm using to get the difference between two dates:
=DATEDIF(B539,A539,"y")&" years, "&DATEDIF(B539,A539,"ym")&" months,
"&DATEDIF(B539,A539,"md")&" days"
Thanks,
da...@gci.net
Leo Heuser
Jun 22, 2001, 6:12:55 AM6/22/01
to
Wanda
Try this setup:
=TEXT(DATEDIF(B539,A539,"y"),"00")&" years,
"&TEXT(DATEDIF(B539,A539,"ym"),"00")&" months,
"&TEXT(DATEDIF(B539,A539,"md"),"00")&" days"
Best regards
LeoH
"Wanda Dale" <da...@gci.net> skrev i en meddelelse
news:B7581EA4.18F%da...@gci.net...
0 new messages