RE: Quick access
Hi Trevor,
Thank you for the forum question.
I need more details about what you want to achieve to be able to help you.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Quick access
Hi Jens
On the course we were able to display current times or dates using a short code
=now() gives current date or time,
My question was, is there a short code like above to display working weeks.
Every year is broken down into 52 weeks so today is in current working week 34.
Hope this clarifies what I was looking for?
Trevor
RE: Quick access
Good Morning Trevor,
Yes you have the Weeknum function.
If you have a date in A1 and in B1 type =Weeknum(A1,2) you will get the week number in B1. If you want the week number of current week you can type =WeekNum(today(),2)
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
