Getting the week number automatically [Solved/Closed]
Posts Saturday August 7, 2010Registration date
August 31, 2010
Aug 19, 2010 at 04:31 AM - Latest reply: rizvisa14481
Posts Thursday January 28, 2010Registration dateContributorStatus
January 6, 2016
- Aug 26, 2010 at 08:26 AM
I need to get the week number automaticlly.. Lets say I enter the a date in Cell A2 then i want Cell B5 to show the respective week number. Lets say for example if today is 18/8/2010 and week should be 33 i recorded a macro and entered it into sheet1 code but nothing happened.. can some one help me correct this code.. thanks.........
ActiveCell.FormulaR1C1 = "=WEEKNUM(R[-3]C)"