Although it is easy enough to work out the month or year of an Excel date, using the MONTH and YEAR functions, it is not as obvious to work out what week of the year a date falls in.
However there is a function called WEEKNUM which we can use.
The syntax for this is
=WEEKNUM(serial number, return type), where serial number is the cell containing the date and return type is a number 1 or 2 which indicates whether you want the week to begin on a Sunday (1 or omitted) or a Monday (2).
You will then see the relevant week number.
When using Pivot tables, it is easy enough to group dates by Day, Month, Quarter or Year, but not so easy to group on a weekly basis, unless you use the WEEKNUM function. If you use the resulting field as a row label in your Pivot Table, you then have weekly data.
Find out more about our Microsoft Excel training London, UK.
Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.