WEEKNUM function in excel will return the relative week number to the given input date. It will also return a **#NUM! error** if the **return_type** argument is not supported. By default the Excel ...
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 ...