You can use this non Array function to Calculate the day to completion of starting month
=DAY(DATE(YEAR(A2),MONTH(A2)+1,0)-DAY(A2)+1) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: 05 May 2012 16:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days Hi, Find the attachment..... Regards, MARIES. On Fri, May 4, 2012 at 11:03 PM, Vijayendra Rao <vijayendrar...@gmail.com> wrote: 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 <tel:94491%2067631> -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, <tel:%E0%B3%AF%E0%B3%AA%E0%B3%AA%E0%B3%AF%E0%B3%A7%20%E0%B3%AC%E0%B3%AD%E0%B3%AC%E0%B3%A9%E0%B3%A7> ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 <tel:94491%2067631> -- 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 -- 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
