Calculate weeks between two dates (working Days)

Hi Guys, I wanted to know how I could calculate how many weeks have elapsed between two dates.

I have a start date and end date in Date format and then I use the formula NETWORKDAYS(Start Date,End Date)/5), formatted to 2 decimal places this tells how many weeks have elapsed between the two dates.

Now I wanted to do the reverse, So basically I would have a Start Date, then the number of weeks and from this calculate the End Date using working days only.

Is this possible?

Thanks in advance for any help given.

@daddylonglegs

Thanks for the info. I shall test it out.

Originally Posted by daddylonglegs

Hello Michael, I inserted a deliberate error in that formula, did you spot it?

Of course if B1 has the number of weeks you'd need to multiply by 5 to get the days, not divide, so it'd be

=WORKDAY(A1,ROUND(B1*5,0))

Yes I thought there was a problem when the formula did not quite work. I had to enter another formula into the cellcell: (B1*5)-1).

Now I have another question. If I know the END Date and the number of weeks. How do I then calculate the Start Date?

Thanks in advance.

@daddylonglegs

Wow! Thank you so much I did not know how to reverse the days.

This is a great help and I really appreciate it.