Carmel has attended:
Excel Intermediate course
Working with Dates
I need to set up a date range from mid May 2022 to end November only showing Mondays and Friday e.g. 09/05/2022 13/05/2022 at the top of each column. Rather than having to type each date in, is there a quick way of displaying my dates?
RE: Working with Dates
Hi Carmel,
I hope you are fine and thank you for the forum question.
There is a simple solution.
Type in the first Monday date (09/05/2022) and in the next cell type the first Friday date (13/05/2022).
In the cell next to the Friday date type = and click on the cell with the first Monday date and type +7 after the cell reference (to add 7 days to the date). Press Ctrl Enter. Use the fill handle (the handle bottom right) and drag across to the right as far as you need.
I hope this makes sense.
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
