年尾做定美國假期表:
|
| 2015 | 2016 |
美國假期 | Day Observed | Date | Date |
New Years Day
| /01/01 | 01/01/2015 | 01/01/2016 |
Martin L King's Bday
| 3rd Mon in Jan
| 01/19/2015 | 01/18/2016 |
Presidents' Day
| 3rd Mon in Feb
| 02/16/2015 | 02/15/2016 |
Memorial Day
| Last Mon in May
| 05/25/2015 | 05/30/2016 |
Independence Day
| /7/4 | 07/04/2015 | 07/04/2016 |
Labor Day | 1st Mon in Sept | 09/07/2015 | 09/05/2016 |
Columbus Day
| 2nd Mon in Oct
| 10/12/2015 | 10/10/2016 |
Veteran’s Day
| /11/11 | 11/11/2015 | 11/11/2016 |
Thanksgiving Day
| 4th Thu in Nov
| 11/26/2015 | 11/24/2016 |
Christmas Day
| /12/25 | 12/25/2015 | 12/25/2016 |
New Years Eve | /12/31 | 12/31/2015 | 12/31/2016 |
|
|
|
|
|
| 2017 | 2018 |
美國假期 | Day Observed | Date | Date |
New Years Day
| /01/01 | 01/01/2017 | 01/01/2018 |
Martin L King's Bday
| 3rd Mon in Jan
| 01/16/2017 | 01/15/2018 |
Presidents' Day
| 3rd Mon in Feb
| 02/20/2017 | 02/19/2018 |
Memorial Day
| Last Mon in May
| 05/29/2017 | 05/28/2018 |
Independence Day
| /7/4 | 07/04/2017 | 07/04/2018 |
Labor Day | 1st Mon in Sept | 09/04/2017 | 09/03/2018 |
Columbus Day
| 2nd Mon in Oct
| 10/09/2017 | 10/08/2018 |
Veteran’s Day
| /11/11 | 11/11/2017 | 11/11/2018 |
Thanksgiving Day
| 4th Thu in Nov
| 11/23/2017 | 11/29/2018 |
Christmas Day
| /12/25 | 12/25/2017 | 12/25/2018 |
New Years Eve | /12/31 | 12/31/2017 | 12/31/2018 |
複製內容到剪貼板
代碼:
假如 C1 放 2015,計出 一月第三個星期一的公式:
=IF(WEEKDAY(DATE(C$1,1,1))<3, DATE(C$1,1,1)+16-WEEKDAY(DATE(C$1,1,1)),DATE(C$1,1,1)+23-WEEKDAY(DATE(C$1,1,1)))
計出 二月第三個星期一的公式:
=IF(WEEKDAY(DATE(C$1,2,1))<3, DATE(C$1,2,1)+16-WEEKDAY(DATE(C$1,2,1)),DATE(C$1,2,1)+23-WEEKDAY(DATE(C$1,2,1)))
計出 五月最後一個星期一的公式:
=IF(WEEKDAY(DATE(C$1,6,1))<3, DATE(C$1,6,1)-5-WEEKDAY(DATE(C$1,6,1)),DATE(C$1,6,1)+2-WEEKDAY(DATE(C$1,6,1)))
計出 九月第一個星期一的公式:
=IF(WEEKDAY(DATE(C$1,9,1))<3, DATE(C$1,9,1)+2-WEEKDAY(DATE(C$1,9,1)),DATE(C$1,9,1)+9-WEEKDAY(DATE(C$1,9,1)))
計出 十月第二個星期一的公式:
=IF(WEEKDAY(DATE(C$1,10,1))<3, DATE(C$1,10,1)+9-WEEKDAY(DATE(C$1,10,1)),DATE(C$1,10,1)+16-WEEKDAY(DATE(C$1,10,1)))
計出 十一月第四個星期四的公式:
=IF(WEEKDAY(DATE(C$1,11,1))<5, DATE(C$1,11,1)+26-WEEKDAY(DATE(C$1,11,1)),DATE(C$1,11,1)+33-WEEKDAY(DATE(C$1,11,1)))
廿年前仲用緊 DOS的年代,我有條公式計今日星期幾就出到 年曆了。
下月一日星期幾 減 本月一日星期幾:
負數加35;正數加28 就是本月的總日數。