Excel Formula

  • Thread starter Thread starter Glenn Robertson
  • Start date Start date
G

Glenn Robertson

Hi, hope someone can help.
What I need to find is a formula that will do the
following: I have two coloumns, the first is titled (From)
and is in dd/mm/yy format, the second coloumn is titled
(To) and is in dd/mm/yy format. I need a formula for the
third coloumn that will look at the From and To coloumns
and tell me the number of working days, e.g.

HOLIDAY TAKEN

FROM TO NO OF DAYS

24/01/03 25/01/03 2

thanks
 
Glenn Robertson said:
Hi, hope someone can help.
What I need to find is a formula that will do the
following: I have two coloumns, the first is titled (From)
and is in dd/mm/yy format, the second coloumn is titled
(To) and is in dd/mm/yy format. I need a formula for the
third coloumn that will look at the From and To coloumns
and tell me the number of working days, e.g.

HOLIDAY TAKEN

FROM TO NO OF DAYS

24/01/03 25/01/03 2

thanks
Click to expand...

Take a look at the NETWORKDAYS function. (Note that this requires the
Analysis Add-In to be enabled.)
 
Hey

This is easy!

If First date is in Coloumn A and second date in coloumn
B, just in C write =day(B-A) and then format cell C as a
number. The answer will be one since there is one day
between 24/01/03 and 25/01/03. If you need both day
included as a holiday simply in the formula in coloumn C
=day(B-A)+1.

Excel is very good to use when calc. with date, days and
weeks and months.

The trick is using the format cell and then turn it to a
number.

Good luck!

Olaf
 
Back
Top