Computing Dates of Fathers Day with Excel

Quote of the Day

I think a man only needs one thing in life. He just needs someone to love. If you can't give him that, then give him something to hope for. And if you can't give him that, just give him something to do.

— Great quote from the movie 'Flight of the Phoenix.'


Introduction

Table 1: Years where Fathers Day and My Anniversary Coincide.

Table 1: Years where Fathers Day and My Anniversary Coincide.

My wedding anniversary (16-June) and Fathers Day are on the same weekend this year. Next year, Fathers Day and my anniversary are on the same day. I became curious about (a) how to compute the date of Fathers Day for each year, and (b) determining the years when Fathers Day and my anniversary occur on the same date. Since the calculation is simple and table-oriented, I will use Excel for this project. Table 1 shows the years with Fathers Days that coincide with my anniversary. I generated this table by filtering the comprehensive list for all Fathers Days on the 16th. Figure 2 shows how I derived my Excel formula. My approach was to look at the latest possible Fathers Day and then determine a correction based on the day of the week that the latest possible Fathers Day falls on. Table 3 is the comprehensive list that shows the dates for every Father's day for the next 100 years.

For those who are interested, my Excel Workbook can be found here.

YearFather's Day
201916-June-2019
202021-June-2020
202120-June-2021
202219-June-2022
202318-June-2023
202416-June-2024
202515-June-2025
202621-June-2026
202720-June-2027
202818-June-2028
202917-June-2029
203016-June-2030
203115-June-2031
203220-June-2032
203319-June-2033
203418-June-2034
203517-June-2035
203615-June-2036
203721-June-2037
203820-June-2038
203919-June-2039
204017-June-2040
204116-June-2041
204215-June-2042
204321-June-2043
204419-June-2044
204518-June-2045
204617-June-2046
204716-June-2047
204821-June-2048
204920-June-2049
205019-June-2050
205118-June-2051
205216-June-2052
205315-June-2053
205421-June-2054
205520-June-2055
205618-June-2056
205717-June-2057
205816-June-2058
205915-June-2059
206020-June-2060
206119-June-2061
206218-June-2062
206317-June-2063
206415-June-2064
206521-June-2065
206620-June-2066
206719-June-2067
206817-June-2068
206916-June-2069
207015-June-2070
207121-June-2071
207219-June-2072
207318-June-2073
207417-June-2074
207516-June-2075
207621-June-2076
207720-June-2077
207819-June-2078
207918-June-2079
208016-June-2080
208115-June-2081
208221-June-2082
208320-June-2083
208418-June-2084
208517-June-2085
208616-June-2086
208715-June-2087
208820-June-2088
208919-June-2089
209018-June-2090
209117-June-2091
209215-June-2092
209321-June-2093
209420-June-2094
209519-June-2095
209617-June-2096
209716-June-2097
209815-June-2098
209921-June-2099
210020-June-2100
210119-June-2101
210218-June-2102
210317-June-2103
210415-June-2104
210521-June-2105
210620-June-2106
210719-June-2107
210817-June-2108
210916-June-2109
211015-June-2110
211121-June-2111
211219-June-2112
211318-June-2113
211417-June-2114
211516-June-2115
211621-June-2116
211720-June-2117
211819-June-2118
Figure 2: Rationale Behind Excel Formula. Table 2: Fathers Day for the Next 100 years.
 
This entry was posted in Excel, Math Education. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *