Forum Home
Press F1
Thread ID: 4692	2000-06-19 12:52:00	Excel Weeknum Function	Guest (0)	Press F1

Post ID	Timestamp	Content	User
5184	2000-06-19 12:52:00	I have been trying to get a cell in Excel to return the week number of the year automatically. I have tried using the 'Weeknum' function but can't get that to work. When I enter =weeknum('19/06/2000',1) it returns #name. Even if it did work, I still have to enter the date into the argument. I was hoping to use the weeknum function in conjuction with teh Now() function to get it to automatically return the correct week number when the worksheet is opened. Any help would be appreciated. Thanks John Robb	Guest (0)
1