Thanks Andy, It works very well.
Thanks thank you so much...! Regards, Avinash On Sunday, April 22, 2012 12:18:50 AM UTC+5:30, Andy wrote: > > Dear Avinash, > > My mistake.. I forgot I am using Excel 2010 and shd have been careful. > > Looks like the part of the formula *WEEKDAY(C2,17)* caused the issue. > > Change it to *WEEKDAY(C2,1)* > * > * > **** 17 in excel 2010 pertains to the * "*Numbers 1 (Sunday) through 7 > (Saturday)" and is not supported in versions below 2010. * > *Use 1 instead of 17 as it behaves like previous versions of Microsoft > Excel. * > * > * > *That will work for you..* > * > * > *So your final formula will be* > *="Week Ending - "&TEXT(C2+7-WEEKDAY(C2,1),"dd-mmm-yyyy")* > * > * > *Cheers,* > *Andy* > *HTH > * > > Thanks Andy, >> >> I saw the sheet which u have attached and the results also but when i >> tried to press enter to that cell it is automatically showing me ( >> #NUM!) error message i don't know what is the issue i am using excel >> 2007. Please help >> >> >> regards, >> >> Avinash. >> >> >> On Saturday, April 21, 2012 10:18:38 PM UTC+5:30, Andy wrote: >> >>> Dear Avinash, >>> >>> Use the Formula - *="Week Ending - "&TEXT(C2+7-WEEKDAY(C2,17)," >>> dd-mmm-yyyy")* >>> This is for the first Row in your records, and can be copied down. >>> >>> Attached is the solved Sheet. >>> >>> Hope this Helps.... >>> >>> Cheers, >>> Andy >>> HTH >>> >>> >>> Dear Masters, >>>> >>>> Please find attached sheet for better understanding, i want help >>>> regarding week ending formula to determine week ending. >>>> >>>> >>>> Regards, >>>> >>>> Avinash >>>> >>>> -- >>>> 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. >>>> >>>> ------------------------------**------------------------------** >>>> ------------------------------**------------ >>>> >>>> >>> >>> >>> >>> >>> -- >> 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. >> >> >> ------------------------------------------------------------------------------------------------------ >> >> > > > -- > > Warm Regards, > Aindril De > Ph: 9811300157 > > -- 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
