Get Bi-Weekly Paydays And Major US Holidays With PowerShell

Example PowerShell code to generate paydays and holidays with or without full calendar. The Holiday function could be shorter and more elegant, but it works for my needs.
<#
Basic functions to get bi-weekly pay and major holidays.
May need alterations on Windows or Mac. I am on Linux.
Author: C. Nichols
#>
function Get-Paydays () {
    param (
        [int]$FirstPayMonth = 1,
        [int]$FirstPayDay = 12,
        [int]$Year = 2024
    )
 
    $WeekNum = @{
        Sunday=0;
        Monday=1;
        Tuesday=2;
        Wednesday=3;
        Thursday=4;
        Friday=5;
        Saturday=6
    }
 
    if (-not($Year)) {
        $CurrentYear = (Get-Date).Year
    } else {
        $CurrentYear = $Year
    }
 
    $FirstPayOfYear = Get-Date -Year $CurrentYear -Month $FirstPayMonth -Day $FirstPayDay
    $EndOfYear = Get-Date -Year $CurrentYear -Month 12 -Day 31
 
    $CurrentDate = $FirstPayOfYear
    $Paydays = New-Object -TypeName "System.Collections.ArrayList"
    While ($CurrentDate -lt $EndOfYear)
    {
 
        If ($CurrentDate.DayOfWeek -eq 'Friday') {
 
            $MonthName  = (Get-Culture).DateTimeFormat.GetMonthName($CurrentDate.Month)
            $DayName = $CurrentDate.DayOfWeek.ToString()
 
            $PayDate = [PsCustomObject]@{
                MonthName=$MonthName;
                Month=$CurrentDate.Month;
                WeekIndex=$WeekNum[$DayName];
                DayName=$DayName;
                Day=$CurrentDate.Day;
                Year=$CurrentYear;
                Desc="payday"
            }
           
            $Paydays += $PayDate
        }
 
        $CurrentDate = $CurrentDate.AddDays(14)
 
    }
 
    return $Paydays
}
 
function Get-Holidays() {
    PARAM (
        [int]$Year=2024
    )
 
    $WeekNum = @{
        Sunday=0;
        Monday=1;
        Tuesday=2;
        Wednesday=3;
        Thursday=4;
        Friday=5;
        Saturday=6
    }
 
    $FIXED_HOLIDAYS = @{12=@{25="Christmas Day"};
                        1=@{1="New Year's Day"};
                        6=@{19="Juneteenth"};
                        7=@{4="Independence Day"};
                        11=@{11="Veteran's Day"}
                        }
 
    $HOLIDAYS = @{1=@{3="Martin Luther King, Jr.Birthday"};  # 3rd Monday in Jan.
                    2=@{3="President's Day"};                # 3rd Monday in Feb. (President's Day)
                    #5="memorial";                           # Last Monday in May. Handled separately.
                    9=@{1="Labor Day"};                      # 1st Monday in Sept.
                    10=@{2="Columbus Day"};                  # 2nd Monday in Oct.
                    11=@{4="Thanksgiving"}                   # 4th Thursday in Nov.
                    }
   
    $HolidayCalendar = @{}
    $Calendar = @{}
    $Rows = New-Object -TypeName "System.Collections.ArrayList"
 
    if (-not($Year)) {
        $Year = (Get-Date).Year
    }
   
    # Link month name to day names for year.
    ForEach ($Month in 1..12) {
 
        $DaysInMonth = [datetime]::DaysInMonth($Year,$Month)
 
        ForEach ($Day in 1..$DaysInMonth) {
 
            $DateObject = Get-Date -Year $Year -Month $Month -Day $Day
            $DayName = $DateObject.DayOfWeek
 
            if (-not($Calendar.ContainsKey($Month))) {
                $Calendar[$Month] = @{}
            }
 
            $Calendar[$Month][$Day] = $DayName
 
        }
    }
 
    # Get a increamental count of each weekday in month.
    $MonthKeys = $Calendar.Keys
    ForEach ($MonthKey in $MonthKeys | Sort-Object) {
 
        $DayHash = $Calendar[$MonthKey]
        $MonCount = 0
        $MemArray = @()
 
        $DayKeys = $DayHash.Keys
        ForEach ($DayKey in $DayKeys | Sort-Object) {
           
            $MonthDays = $DayHash[$DayKey]
            $Holiday = ""
 
            if ($FIXED_HOLIDAYS.ContainsKey($MonthKey)) {
 
                $Holiday = $FIXED_HOLIDAYS[$MonthKey][$DayKey]
 
            }
 
            if ($MonthDays -eq "Monday") {
                $MonCount += 1
                if ($HOLIDAYS.ContainsKey($MonthKey)) {
                    if ($HOLIDAYS[$MonthKey].ContainsKey($MonCount)) {
 
                        $Holiday = $HOLIDAYS[$MonthKey][$MonCount]
 
                    }
                }
            }
 
            if ($MonthKey -eq 5) {
                
                if ($MonthDays -eq "Monday") {
                    $MemArray += $DayKey
                }
            }
 
            if (-not($HolidayCalendar.ContainsKey($MonthKey))) {
                $HolidayCalendar[$MonthKey] = @{}
            }
 
            if (-not($HolidayCalendar[$MonthKey].ContainsKey($DayKey))) {
                $HolidayCalendar[$MonthKey][$DayKey] = ""
            }
           
            $HolidayCalendar[$MonthKey][$DayKey] = $Holiday
        }
 
        if ($MemArray[-1]) {
 
            $Memday = $MemArray[-1]
           
            $HolidayCalendar[5][$Memday] = "Memorial Day"
        }
    }
 
    $MthKeys = $HolidayCalendar.Keys
    ForEach ($mk in $MthKeys | Sort-Object) {
 
        $MonthName = (Get-Culture).DateTimeFormat.GetMonthName($mk)
        #Write-Host $MonthName
 
        $DayKeys = $HolidayCalendar[$mk].Keys
        ForEach ($dk in $DayKeys | Sort-Object) {
 
            $DateObject = Get-Date -Year $Year -Month $mk -Day $dk
            $DayName = $DateObject.DayOfWeek.ToString()
           
            $HolidayDesc = $null
            if ($HolidayCalendar[$mk][$dk]) {
                $HolidayDesc = $HolidayCalendar[$mk][$dk]
            }
 
            if ($DayName -eq "Saturday") {
                $DateObject = $DateObject.AddDays(-1)
                $DayName = $DateObject.DayOfWeek.ToString()
            }
 
            if ($DayName -eq "Sunday") {
                $DateObject = $DateObject.AddDays(1)
                $DayName = $DateObject.DayOfWeek.ToString()
            }
 
            $Columns = [PsCustomObject]@{
                MonthName=$MonthName;
                Month=$mk;
                WeekIndex=$WeekNum[$DayName];
                DayName=$DayName;
                Day=$dk;
                Year=$Year;
                Desc=$HolidayDesc
            }
           
            $Rows += $Columns
 
        }
    }
    return $Rows
}
 
<# Main ::
    Merge and offset clashes.
#>
$WeekNum = @{
    Sunday=0;
    Monday=1;
    Tuesday=2;
    Wednesday=3;
    Thursday=4;
    Friday=5;
    Saturday=6
}
 
$MergedRows = @()
$DateHash = @{}
 
# Ge major holidays.
$MyHolidays = Get-Holidays #-Year 2026
$MyPaydays = Get-Paydays #-Year 2026 -FirstPayMonth 1 -FirstPayDay 9
 
ForEach ($p in $MyPaydays) {
    $Pdate = Get-Date -Year $p.Year -Month $p.Month -Day $p.Day
    if (-not($DateHash.ContainsKey($Pdate.Date))) {
       $DateHash[$Pdate.Date] = $p
    }
}
 
ForEach ($h in $MyHolidays) {
    if ($h.Desc) {
        $Hdate = Get-Date -Year $h.Year -Month $h.Month -Day $h.Day
        if (-not($DateHash.ContainsKey($Hdate.Date))) {
            $DateHash[$Hdate.Date] = $h
        } else {
            $Pdate = Get-Date -Year $DateHash[$Hdate.Date].Year -Month $DateHash[$Hdate.Date].Month -Day $DateHash[$Hdate.Date].Day
            $Pdate = $Pdate.AddDays(-1)
            $MonthName = (Get-Culture).DateTimeFormat.GetMonthName($Pdate.Month)
            $DayName = $Pdate.DayOfWeek.ToString()
            $Column = [PsCustomObject]@{
                MonthName=$MonthName;
                Month=$Pdate.Month;
                WeekIndex=$WeekNum[$DayName];
                DayName=$DayName;
                Day=$Pdate.Day;
                Year=$Pdate.Year;
                Desc="payday"
            }
            $DateHash[$Hdate.Date] = $h
            $DateHash[$Pdate.Date] = $Column
        }
    }
}
 
# create report.
$ReportRows = @()
$DateKeys = $DateHash.Keys
ForEach ($mdate in $DateKeys | Sort-Object) {
    Write-Host $DateHash[$mdate]
    $ReportRows += $DateHash[$mdate]
}
# Save as CSV.
#$ReportRows | Export-Csv -Path "~/PrCal.csv" -NoTypeInformation

<# OUTPUT
@{MonthName=January; Month=1; WeekIndex=1; DayName=Monday; Day=1; Year=2024; Desc=New Year's Day}
@{MonthName=January; Month=1; WeekIndex=5; DayName=Friday; Day=12; Year=2024; Desc=payday}
@{MonthName=January; Month=1; WeekIndex=1; DayName=Monday; Day=15; Year=2024; Desc=Martin Luther King, Jr.Birthday}
@{MonthName=January; Month=1; WeekIndex=5; DayName=Friday; Day=26; Year=2024; Desc=payday}
@{MonthName=February; Month=2; WeekIndex=5; DayName=Friday; Day=9; Year=2024; Desc=payday}
@{MonthName=February; Month=2; WeekIndex=1; DayName=Monday; Day=19; Year=2024; Desc=President's Day}
@{MonthName=February; Month=2; WeekIndex=5; DayName=Friday; Day=23; Year=2024; Desc=payday}
@{MonthName=March; Month=3; WeekIndex=5; DayName=Friday; Day=8; Year=2024; Desc=payday}
@{MonthName=March; Month=3; WeekIndex=5; DayName=Friday; Day=22; Year=2024; Desc=payday}
@{MonthName=April; Month=4; WeekIndex=5; DayName=Friday; Day=5; Year=2024; Desc=payday}
@{MonthName=April; Month=4; WeekIndex=5; DayName=Friday; Day=19; Year=2024; Desc=payday}
@{MonthName=May; Month=5; WeekIndex=5; DayName=Friday; Day=3; Year=2024; Desc=payday}
@{MonthName=May; Month=5; WeekIndex=5; DayName=Friday; Day=17; Year=2024; Desc=payday}
@{MonthName=May; Month=5; WeekIndex=1; DayName=Monday; Day=27; Year=2024; Desc=Memorial Day}
@{MonthName=May; Month=5; WeekIndex=5; DayName=Friday; Day=31; Year=2024; Desc=payday}
@{MonthName=June; Month=6; WeekIndex=5; DayName=Friday; Day=14; Year=2024; Desc=payday}
@{MonthName=June; Month=6; WeekIndex=3; DayName=Wednesday; Day=19; Year=2024; Desc=Juneteenth}
@{MonthName=June; Month=6; WeekIndex=5; DayName=Friday; Day=28; Year=2024; Desc=payday}
@{MonthName=July; Month=7; WeekIndex=4; DayName=Thursday; Day=4; Year=2024; Desc=Independence Day}
@{MonthName=July; Month=7; WeekIndex=5; DayName=Friday; Day=12; Year=2024; Desc=payday}
@{MonthName=July; Month=7; WeekIndex=5; DayName=Friday; Day=26; Year=2024; Desc=payday}
@{MonthName=August; Month=8; WeekIndex=5; DayName=Friday; Day=9; Year=2024; Desc=payday}
@{MonthName=August; Month=8; WeekIndex=5; DayName=Friday; Day=23; Year=2024; Desc=payday}
@{MonthName=September; Month=9; WeekIndex=1; DayName=Monday; Day=2; Year=2024; Desc=Labor Day}
@{MonthName=September; Month=9; WeekIndex=5; DayName=Friday; Day=6; Year=2024; Desc=payday}
@{MonthName=September; Month=9; WeekIndex=5; DayName=Friday; Day=20; Year=2024; Desc=payday}
@{MonthName=October; Month=10; WeekIndex=5; DayName=Friday; Day=4; Year=2024; Desc=payday}
@{MonthName=October; Month=10; WeekIndex=1; DayName=Monday; Day=14; Year=2024; Desc=Columbus Day}
@{MonthName=October; Month=10; WeekIndex=5; DayName=Friday; Day=18; Year=2024; Desc=payday}
@{MonthName=November; Month=11; WeekIndex=5; DayName=Friday; Day=1; Year=2024; Desc=payday}
@{MonthName=November; Month=11; WeekIndex=1; DayName=Monday; Day=11; Year=2024; Desc=Veteran's Day}
@{MonthName=November; Month=11; WeekIndex=5; DayName=Friday; Day=15; Year=2024; Desc=payday}
@{MonthName=November; Month=11; WeekIndex=1; DayName=Monday; Day=25; Year=2024; Desc=Thanksgiving}
@{MonthName=November; Month=11; WeekIndex=5; DayName=Friday; Day=29; Year=2024; Desc=payday}
@{MonthName=December; Month=12; WeekIndex=5; DayName=Friday; Day=13; Year=2024; Desc=payday}
@{MonthName=December; Month=12; WeekIndex=3; DayName=Wednesday; Day=25; Year=2024; Desc=Christmas Day}
@{MonthName=December; Month=12; WeekIndex=5; DayName=Friday; Day=27; Year=2024; Desc=payday}
#>
Blog

Get Bi-Weekly Paydays And Major US Holidays With PowerShell

Like this:

Mohawke

Recent Posts

Categories

Links
