PDA

View Full Version : Excel Weeknum Function



20-06-2000, 12:52 AM
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