ImportExcel/Examples/ConditionalFormatting/GenDates.ps1 at UpdateGetExcelInfo · SQLvariant/ImportExcel · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
function Get-DateOffset {
    param($days=0)

    (Get-Date).AddDays($days).ToShortDateString()
}

function Get-Number {
    Get-Random -Minimum 10 -Maximum 100
}

New-PSItem (Get-DateOffset -7)  (Get-Number) 'LastWeek,Last7Days,ThisMonth' @('Date', 'Amount', 'Label')
New-PSItem (Get-DateOffset)     (Get-Number) 'Today,ThisMonth,ThisWeek'
New-PSItem (Get-DateOffset -30) (Get-Number) LastMonth
New-PSItem (Get-DateOffset -1)  (Get-Number) 'Yesterday,ThisMonth,ThisWeek'
New-PSItem (Get-DateOffset)     (Get-Number) 'Today,ThisMonth,ThisWeek'
New-PSItem (Get-DateOffset -5)  (Get-Number) 'LastWeek,Last7Days,ThisMonth'
New-PSItem (Get-DateOffset 7)   (Get-Number) 'NextWeek,ThisMonth'
New-PSItem (Get-DateOffset 28)  (Get-Number) NextMonth
New-PSItem (Get-DateOffset)     (Get-Number) 'Today,ThisMonth,ThisWeek'
New-PSItem (Get-DateOffset -6)  (Get-Number) 'LastWeek,Last7Days,ThisMonth'
New-PSItem (Get-DateOffset -2)  (Get-Number) 'Last7Days,ThisMonth,ThisWeek'
New-PSItem (Get-DateOffset 1)  (Get-Number) 'Tomorrow,ThisMonth,ThisWeek'