MS Excel : Perform DATE CALCULATIONS

MS Excel : Perform DATE CALCULATIONS


A special purpose date and time function allows
to locate the quantity of working days between two
dates Like other Excel functions, Date and time
The functions make use of the Function Assistant. The same as
All functions, the assistant works with the data you write
in the wizard, as a specific date, and with
data that you have written in cells in your worksheet.

To ascertain the quantity of working days between two
dates, use the NETWORKDAY function. the
The arguments of the function include a start date, an end date
date, and optionally, any holiday involved
automatically reduce the number of working days
Between the two dates. Excel automatically deduces
The number of weekend dates.

Excel can perform date arithmetic at any later date
January 1, 1900. If you use earlier dates,
Excel treats them as text and does not work
A calculation about them. Instead, it gives you a
#VALUE! error.


MS Excel : Perform DATE CALCULATIONS


FIND NUMBER OF DAYS BETWEEN
TWO DATES
1 Enter the start date.
2 Enter the end date.
l If you want the calculation
consider vacations, write dates
on vacation between the start
and completion dates.
3 Click on the field in which you want
The result to appear.
4 Click the Insert Function button.

FIND NUMBER OF DAYS BETWEEN TWO DATES 1 Enter the start date. 2 Enter the end date. l If you want the calculation consider vacations, write dates on vacation between the start and completion dates. 3 Click on the field in which you want The result to appear. 4 Click the Insert Function button.


The Insert Function dialog box
appears.
5 Click here and select Date and
Hour.
6 Double-click NETWORKDAYS.

The Insert Function dialog box appears. 5 Click here and select Date and Hour. 6 Double-click NETWORKDAYS.


The function
Argument Dialog
the picture appears
7 Click on the cell
which contains the beginning
date or type cell
address.
8 Click on the cell
which contains the end
date or type cell
address.
Optionally, click and
drag the range of
holiday or write the
distance.
9 Click OK.

The function Argument Dialog the picture appears 7 Click on the cell which contains the beginning date or type cell address. 8 Click on the cell which contains the end date or type cell address. Optionally, click and drag the range of holiday or write the distance. 9 Click OK.


The cell with the formula shows the network
working days between the two dates.

Did you know

In Excel you can enter the current one
date simply by clicking on the cell
where do you want the date to
appear and press Ctrl and
semicolon keys at the same time.

Did you know

There are more than 15 ways in which
you can format a date, including
August 1, 1956; August 1, 1956;
01-August-56, Wednesday, August,
1956, 8/1; and 8/1/56.

Did you know

When calculating NETWORKDAYS,
if your start date is after your
end date, Excel returns a negative
number.