calculate day using date

  • Thread starter Thread starter Johnnyb
  • Start date Start date
J

Johnnyb

I am trying to calculate the number of days between 2 dates excludin
weekends. Is it possible to find out using a formula a specific day o
the week by using a date field. This would help me to remove th
weekends and calculate only working days. I do not have days of th
week in my spreadsheet and would like to be able to work it out fro
dates only.

Thankyou,

Johnny
 
Hi Johnnyb

Use the NETWORKDAYS Analysis ToolPak function.

See Help on this and note that the Analysis ToolPak has to be
installed and selected as an addin.
 
Hi Johnnyb

Thanks for thanks. You might also find the WORKDAY function useful for
calculating future dates.
 

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

Calculate 60 days from Start Date - including weekends 5
Calculating 6 days from a date 7
Calculate days help 2
Number of Weekend Days between 2 Dates Q 1
How to calculate dates 6
Scrabble Value calculation for Welsh words 0
Dates 2
Calculating due date? 2

Back
Top