Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

calculating clear days

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculating "clear days"

Calculating "clear days"

ResolvedVersion 365

Simon has attended:
Excel Intermediate course

Calculating "clear days"

I had asked if there was a special formula to calculate days where we can exclude a certain day. For example, if we exclude the start date, but 14 days later.

RE: Calculating "clear days"

Hi Simon,

Thank you for the forum question.

To calculate "clear days" in Excel—where you exclude the start date and count a specific number of days afterward (e.g., 14 days)—you can use a simple formula depending on whether you want to include weekends or not.

If you want to exclude the start date and count calendar days:
Use:

excel
=StartDate + NumberOfDays


But since you want to exclude the start date, you add 1 less day:

excel
=StartDate + 14


This gives you the date 14 clear days after the start date, not counting the start date itself.



If you want to **exclude weekends** (i.e., count only working days):
Use the `WORKDAY` function:

excel
=WORKDAY(StartDate, 14)


This also excludes the start date by default and counts 14 working days forward.

If you want to **include holidays, use:

excel
=WORKDAY(StartDate, 14, Holidays)


Where `Holidays` is a range of cells containing holiday dates.



Example:
If `A1` contains `08/07/2025` (July 8, 2025), then:

=A1 + 14` → July 22, 2025 (14 calendar days after, excluding start date)
=WORKDAY(A1, 14)` → July 26, 2025 (14 working days after, excluding start date)



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

Tue 15 Jul 2025: Automatically marked as resolved.

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.