Forum home » Delegate support and help forum » Microsoft Excel Training and help » Dates

Dates

ResolvedVersion 2010

Wed 23 Sep 2015, 16:57 Delegate Roxanne said...

Roxanne has attended:
Excel Intermediate course

Dates

How do you program dates so that it works out 'working days' only. In law we have to use 'clear days' for service which means 3 days becomes 5.

Tue 29 Sep 2015, 10:21 Trainer Jens said...

RE: Dates

Hi Roxanna,

Thank you for the forum question.

Please have a look at attached workbook. I am using the Networkdays function. You will need to have a list of all the UK bank holidays in your workbook as well to get the right result.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best 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

Attached files...

clear days.xlsx

Tue 6 Oct 2015: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

Dates

Dates

RE: Dates

Attached files...

Excel articles

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command