As well as being a number cruncher, Excel's time and date functions mean the program can also work as a makeshift timekeeper. Let's look at Excel's two functions that calculate a week number based on ...

Does anyone know of a way to use the WEEKNUM function but to have it display the week number relative to a specific date? For example, If my column of dates starts at May 7th, where I would like May ...