Excel: How to convert Calendar Days to Workdays

Example of the Table:

Hello! I have to convert a table that displays shipping times from A to B. A shipment can leave at any day Mon - Fri. And it displays the Lead Time of the shipment in days. The Rows represents Different Countries and Zones where a shipment can travel

A typical value in the table is between 1 - 16.

EDIT:

The Table data is displayed in the idea that if a Shipment leaves on Monday it takes 7 calendar days to reach its destination. So what I would need is a way to subtract weekends from the Raw day count.

For example the First Monday value takes a week to reach it's destination. I would need the "7" to not count the weekend. So it would be "5" workdays.

2 Answers

I've added helper row on top of the original data, so you can use this formula to subtract weekends:
=A3-INT((A3+A$1)/7)*2

If you rework your table to somehow reveal actual start and end dates, you will have NETWORKDAYS() come in handy for calculating the day counts. So:

... here with C3 containing =B3-A3 and D3 =NETWORKDAYS(A3;B3)
(=Net Workdays)

This will also allow for any number of days for the deliveries (as shown in the excel sheet!), and additionally allow to remove holidays by adding these to a list, with that list passed as an additional argument to NETWORKDAYS()