# Calculate elapsed calendar weeks between 2 dates

#### malc1982

##### New Member
Need to Calculate elapsed calendar weeks between 2 dates for a presentation

it's doing my nut in

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Hi Malc,

What day of the week does your calendar week start on. How do you want to treat part weeks?

will only be a 5 day calender week mon-fri.

Got a start date column proceeded by an end date column need to show the difference

Monthly totals.xls
HIJK
20EndStartNo.Weeks
2124/02/0431/01/043.43
Sheet1

But how do you want to treat part weeks?

Best off just rounding up to 1 week duration rather than just the part period

=ROUNDUP((H21-I21)/7,0)

is it possible to change the decimal to show 0.1 = monday - 0.5 = friday then to 1.1 1 week and monday?

if not thanks for the swift help

Not quite sure what you mean. What happens if your start date is a Thursday and your end date a Monday, i.e. 2 days before your "week" and one day after: - n.3 ?

You could try : =INT(NETWORKDAYS(I21,H21)/5)&" Weeks and "&(NETWORKDAYS(I21,H21)/5-INT(NETWORKDAYS(I21,H21)/5))*5&" days"

Thursday - Monday should be .3

Replies
2
Views
276
Replies
3
Views
141
Replies
3
Views
223
Replies
3
Views
553
Replies
0
Views
188

1,203,524
Messages
6,055,906
Members
444,832
Latest member
bgunnett8

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back