LinkBack URL
About LinkBacks
Need a date diff but not just days DD/MM/YY format.
Can only find a days difrence
Need a date diff but not just days DD/MM/YY format.
Can only find a days difrence
Last edited by AliGW; 09-09-2018 at 06:08 AM.
Formula:
Please Login or Register to view this content.
will show the number of months and "y" instead of "m" the number of years.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi
Can you show an example to help us?
I have changed your thread title to better explain your request. In future, please adhere to these simple rules for thread titles:
- Use concise, accurate thread titles.
- Your post title should describe your problem, not your anticipated solution.
- Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
- Responding to a request to change your thread title by doing so is mandatory.
To change a title go to your first post, click EDIT then Go Advanced and change your title.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
So you want something like this?
=DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months "&DATEDIF(A1,A2,"md")&" days"
Which will give lapsed time (age) in years, months and days.
The order of the 3 datedifs can be changed as needed.
Last edited by jason.b75; 09-10-2018 at 03:15 AM.
But how about this?
=DATEDIF(start_date,end_date,"y,m,d")
Not with a single function.
If you want the result in that format, change " years " to "," etc.
https://support.office.com/en-us/art...d-8b32a451b35c
Need a date diff but not just days DD/MM/YY format.You've had a lot of answers but it looks to me like you are misunderstanding the datdif function (or any date where you are showing the difference between two dates).Need a date diff but not just days DD/MM/YY format.
the datdif function will show you either years, months, days or years and months or years and days that are the difference between two dates.
So if the date dif was 47 days how would showing it as 02/16/1900 give you any understanding of the answer? You can throw a text function into the formula like =text(dated(B1,A1,"d"),"dd/mm/yy") but it will show a (for example) difference of 47 days as 16/02/00 which doesn't make sense.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
But =TEXT(DATEDIF(B1,A1,"d"),"y ""years,"" m ""months and ""d ""days.""") is more readable.Originally Posted by Sambo kid
00 years, 2 months and 16 days.
Yes Jose, that occurred to me after I posted and while out jogging that maybe what otuatail was wanting, and I have a canned one already I use for similar purposes.
=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months, "&DATEDIF(A1,TODAY(),"md")&" days" which will give similar results to yours like...22 years, 8 months, 0 days for example.
It is also extremely inacurate, Jose!
That will always give 2 months, 16 days for a 47 day date difference, where the methods suggested by Sambo and myself will return a more accurate 1 month and 16 - 19 days depending on which months are specified.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks