reverse week count calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a worksheet where I can enter the start date on one cell and
the number of weeks to be worked and get the estimated out date. I now need
to take the estimated out date and the actual out date and get the number of
weeks between the two in order to calculate my estimated budgetary savings.
 
Hi
Have a look at the NETWORkDAYS function. You will need the Analysis Add In
to use it.
=NETWORKDAYS(End Date,Start Date)/5 will give you the number of weeks
between the 2 dates.

If you want to include all days between the 2 dates simply use
=A1-B1
A1 = End Date
B1 = Start Date

HTH
Michael
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Networkdays with negative numbers 4
Calculate # of years 6
calculating weeks worked 2
Automatically add a column to summary sheet if another worksheet i 2
Counting dates, within a list of dates 7
Date calculation help please! 7
Unique Proposal Numbers 3
percentage of individual cell only 3

Back
Top