Auto allocation of week number based on date of completion

Dear All,

Greetings to everyone here. Please I need help with my spreadsheet:

Column G = Date on which a particular task was completed

Column L = Week in which a task was closed


I need Column L to auto fill in the week number based on the date of completion in column G.

Please find attached the Excel spreadsheet - it would be highly appreciated if you could kindly send update the sheet with the condition.

Many thanks in advance.

Regards,

Kash

Hi,

The function WEEKNUM will return the week number of the date selected.

Please Login or Register  to view this content.

Cheers

Many thanks.

Cheers

You are very welcome. Glad I could be of some assistance.

Cheers