Scribd
Upload
14 views3 pages

Days Until December 23 Excluding Weekends

1) The document contains a table with columns for year, month, day, day of week, and formatted date. Various date formats are converted to a consistent format of MM/DD/YYYY. 2) Functions are demonstrated for calculating the number of workdays between two dates, excluding holidays, and putting a date 6 months in the future. 3) An example shows dates reformatted from a serial number to a consistent date format.

Uploaded by

Coco Luis Trinidad Alvarado
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
14 views3 pages

Days Until December 23 Excluding Weekends

1) The document contains a table with columns for year, month, day, day of week, and formatted date. Various date formats are converted to a consistent format of MM/DD/YYYY. 2) Functions are demonstrated for calculating the number of workdays between two dates, excluding holidays, and putting a date 6 months in the future. 3) An example shows dates reformatted from a serial number to a consistent date format.

Uploaded by

Coco Luis Trinidad Alvarado
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

A B C D E F G H I

1
2
3
Putting
4 date Serial
Year Month Day Day of Week together Number
5 1/4/2003 1/4/2003
6 2/1/1901 2/1/1901
7 4-Jan-2003 4-Jan-03
8 January 4, 2003 4-Jan-03
9 1/4/03 4-Jan-03
10 3-Jan-01
11
12
50
13 workdays
from start excluding
Today's date date holidays
14 Start date 1/3/2003
15 Later date 8/4/2003
16 Holidays
17 Workdays between (excluding holidays) 7/4/2003
18 Workdays between (no holidays) 1/20/2003
19
20
21 International Functions
22
23 Start Date 3/14/2011
24 End Date 8/16/2012
25
26 100 workdays later
27 Sunday Monday as weekend
28 Sunday as weekend
29
30 Days Between Start and End Date
31 Sunday Monday as weekend
32 Sunday as weekend
Putting
Serial date 6 months
Number Year Month Day Day of Week together later
1/4/2003 37625 2003 1 4 7 1/4/2003 37806
2/1/1901 398 1901 2 1 6 2/1/1901 579
4-Jan-2003 37625 2003 1 4 7 1/4/2003 37806
January 4, 2003 37625 2003 1 4 7 1/4/2003 37806
1/4/03 37625 2003 1 4 7 1/4/2003 37806

Today's date 1/11/2018


Dates Reformatted
37622 1/1/2003
37623 1/2/2003
37624 1/3/2003
37625 1/4/2003
37626 1/5/2003
37627 1/6/2003
37628 1/7/2003
37629 1/8/2003
37630 1/9/2003
37631 1/10/2003

You might also like