ExcelBanter - =WEEKNUM

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - =WEEKNUM (https://www.excelbanter.com/excel-programming/371416-%3Dweeknum.html)

TheRook

=WEEKNUM

I am using the WEEKNUM function in a worksheet, but excel seem to use Sunday
as the 1st day of the week. Our working week is Monday to Sunday,

Is there anyway of changing it so the Monday is the 1st day of the week?

TheRook

Bob Phillips

=WEEKNUM

=WEEKNUM(A1,2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TheRook" wrote in message
...
I am using the WEEKNUM function in a worksheet, but excel seem to use
Sunday
as the 1st day of the week. Our working week is Monday to Sunday,

Is there anyway of changing it so the Monday is the 1st day of the week?

TheRook

All times are GMT +1. The time now is 03:48 AM.