Project

PSWriteOffice

PowerShell document automation across OfficeIMO's document, spreadsheet, presentation, PDF, Project, Access, EPUB, invoicing, and conversion engines.

View on GitHub Releases Get package
Stars 654
Forks 82
Open issues 1
Total downloads 4,320,051
Release OfficeIMO-v3.5.3
Language: C# Updated: 2026-11-03
Cmdlet

Set-OfficeExcelDateSystem

Aliases: ExcelDateSystem
Module
PSWriteOffice
Aliases
ExcelDateSystem
Inputs
OfficeIMO.Excel.ExcelDocument
Outputs
OfficeIMO.Excel.ExcelDocument
Source
SetOfficeExcelDateSystemCommand.cs:17 Edit on GitHub

Sets the workbook date system used for numeric date serials.

Syntax

Set-OfficeExcelDateSystem
[-DateSystem] <1900|1904|NineteenHundred|NineteenFour>
[-Document] <ExcelDocument>
[-PassThru]
[<CommonParameters>]
#
Parameter set: All Parameter Sets

Examples

Switch a workbook to the 1904 date system.

$workbook | Set-OfficeExcelDateSystem -DateSystem 1904 -PassThru | Save-OfficeExcel

Marks the workbook to use Excel's 1904 date system before saving.

Parameters

-DateSystem String requiredposition: 1
Date system to use for Excel date serials.
Possible values: 1900, 1904, NineteenHundred, NineteenFour
-Document ExcelDocument requiredposition: 0pipeline: True (ByValue)
Workbook to update.
-PassThru SwitchParameter optional
Emit the workbook for further pipeline operations.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.