Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year

Dear Lee, Please use simple.. *=INT(DAY(H7)/7+0.99)* for your format use *=INT(DAY(MID(H9,5,2)&"-"&RIGHT(H9,2)&"-"&LEFT(H9,4))/7+0.99) * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.

Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year

Hi lee, Please find attached formula for your query. Thanks Mukesh - Original Message - From: Sara Lee To: excel-macros@googlegroups.com Sent: Monday, October 31, 2011 6:49 AM Subject: $$Excel-Macros$$ formulas to get the week in the month and week of the year hi i

Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year

Hi Sara, Refer the below thread for feasibility. http://www.excelforum.com/excel-worksheet-functions/639013-number-of-the-week-in-month.html --- Ms.Exl.Learner --- On Mon, Oct 31, 2011 at 6:49 AM, Sara Lee wrote: > hi > > i have a column in excel with t

Re: $$Excel-Macros$$ formulas to get the week in the month and week of the year

Hi Sara, Please find attached the soln. Hope it helps. Rgds, Andy On Mon, Oct 31, 2011 at 6:49 AM, Sara Lee wrote: > hi > > i have a column in excel with the following date format-- > > ship date > 20110801 > 20110823 > 20110903 > > I need another column adjacent to it which gives me the follo

$$Excel-Macros$$ formulas to get the week in the month and week of the year

hi i have a column in excel with the following date format-- ship date 20110801 20110823 20110903 I need another column adjacent to it which gives me the following results for every respective date above-- basically calcualate month and the week in that particular month in below format... Also t