How to calculate difference between two dates in days, months and year. Please refer the attached document.
How to calculate difference between two dates in days, months and year. Please refer the attached document.
Last edited by DeepakS; 12-02-2011 at 04:57 AM.
Have a look at DATEDIF()
See this link
http://www.cpearson.com/excel/datedif.aspx
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Hi
Some others possible soloutions, i give you to my attacement
Regards.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks for your help!!
Is this possible to have a single formula for all the possibilities?
Hi DeepakS.
Formula's in F4 & F5 are the sames.
If you modify the others two, you'll do this(I can not understand why to do this, but anyway..)
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks