Dear Experts In the userform of the attached workbook contains Date of Joining text box and Date of Retirement textbox. The difference of both the values should come to 23 yrs 01 mth 29 days but it is showing as 23 yrs 01 mth 01 day
In my office procedure resultant date should be given 1 bonus day with this, the result should be 23 yrs 01 mnth 30 days In general, as per my office rules 30 days will be considered as 1 month for calculation of salary Final result should come like 23 yrs 02 mths 00 days Pls rectify the problem. regards shankar sb -- 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
total service problem.xls
Description: MS-Excel spreadsheet
