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 * On Sat, Apr 21, 2012 at 11:11 PM, Avinash <avinash007pa...@gmail.com> wrote: > 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. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- 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
<<32F.gif>>
