LinkBack URL
About LinkBacks
Dear All,
I want to find out Year, Month and Day from total number of days. How can I do that? Please help.
Indra
Dear All,
I want to find out Year, Month and Day from total number of days. How can I do that? Please help.
Indra
A hidden relic in the form of DATEDIF().
Parameters = DATEDIF(start date, end date, "format in quotes")
So, DATEDIF(D2,E2,"y") = years
ym = months
md = days
Last edited by daffodil11; 06-25-2014 at 09:41 AM. Reason: Missing syntax
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Hi there,
to get the numbers You provide in sample workbook, You can use:
for Year in I3:Formula:
Please Login or Register to view this content.
for Month in J3:Formula:Please Login or Register to view this content.
for Day in K3:Formula:Please Login or Register to view this content.
Is this something You can work with?
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Thank you very much both of you, daffodil11 and Miroslav R.. It works for me. You are genius.
Indra
You are welcome!
send from my xperia z via tapatalk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks