QUOTE(KG87 @ 23 Nov, 2007 - 06:19 AM)
Its not really a programming question but here goes,
I've a worksheet that works out my partners expenses (its one from the company, and very badly made)
There is a field that displays the week number (45,46,47) etc
I just wondered if there is anyway of using some form of function in Excel to automate this (so the user doesn't have to manually update)
thanks in advance
George
You should be able to use the WEEKNUM function in Excel. Basically it will return the week number within the current year based on a date provided in the spreadsheet.
CODE
=WEEKNUM(A2,1)
A2 would represent the cell location that contains the date and the 1 would be for which day of the week to consider the starting point. In this case, the 1 says to use Sunday as the start of the week. A 2 would be Monday, 3 a Tuesday, etc.
23 Nov, 2007 - 05:19 AM
| 