Calculating Dates

[MBallentine]

I would like to return the number of week days between two dates.

 

[applebyd]

Ah one of the more useful Microserf commands.

You need to use NETWORKDAYS(Date1,Date2)

Or NETWORKDAYS(Cell1,Cell2) if you will.

Have fun.

DaveA

 

[razzandy]

If you ahve 28/08/02 in cell A1 and 27/09/02 in cell b1 then in cell c1 type =b1-a1 and format the cell as General or number!

Hope this helps?

Ryan UK :wink:

 

[Aladin Akyurek]

On 2002-08-28 05:05, MBallentine wrote:
I would like to return the number of week days between two dates.

=B1-A1

where A1 < B1.

If you mean workdays, then:

=NETWORKDAYS(A1,B1,Holidays)

where Holidays refers to a range that houses the holiday days.