Dear Deba Ranjan, Thanks for efforts, I knew this formula and it was not solved my problem.
I need the below details if any one worked 4th October 2011 to 4th May 2012 - Total days worked in which beginning of the month, i.e: 4th oct to 31 st oct is 28 days, It should be zero if he worked full month. - Total completed months i.e. 1st November to 30th April is 6 Months - Total days worked in last month: i.e. 1st May to 4th May is 4 days, It should be zero if he worked full month Regards, Vijayendra 2012/5/4 Deba Ranjan <drdeva...@gmail.com> > *Hi *Vijay, > > You can you try formula, it will help you out.:- > > For Date diffrence:- =DATEDIF(A2,(B2),"md") > > For Month diffrence :- =DATEDIF(A2,(B2),"ym") > > For Year diffrence :- =DATEDIF(A2,(B2),"y") > > > > > > > Thanks & Regards,* > * > > *Deba Ranjan P*** > > On Fri, May 4, 2012 at 12:39 PM, Vijayendra Rao <vijayendrar...@gmail.com > > wrote: > >> Dear All, >> >> >> >> I need date formula for finding how many days and months between two >> different dates. Request you to resolve my query. I have attached is the >> same file. >> >> >> >> Regards, >> >> Vijayendra >> >> 94491 67631 >> >> >> >> -- >> ಧನ್ಯವಾದಗಳು, >> ವಿಜಯೇಂದ್ರ, >> ೯೪೪೯೧ ೬೭೬೩೧ >> >> Regards, >> Vijayendra >> 94491 67631 >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
