Hello
My company work in 4 week periods from the start of the year.
Cell a1 is todays date
I would like cell b1 to show what period we are in. i.e week 1-4 is period 1, 5-8 is period 2
I would like c1 to show what week of the period we are in i.e 123 or 4
I would like d1 to show what day of the period we are in i.e 123456 or 7
and finally how many working days of the period are left. Small issue is we don't work Sundays so this number will be a max of 24.
Thanks in advance
My company work in 4 week periods from the start of the year.
Cell a1 is todays date
I would like cell b1 to show what period we are in. i.e week 1-4 is period 1, 5-8 is period 2
I would like c1 to show what week of the period we are in i.e 123 or 4
I would like d1 to show what day of the period we are in i.e 123456 or 7
and finally how many working days of the period are left. Small issue is we don't work Sundays so this number will be a max of 24.
Thanks in advance