Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 606 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/
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

Authored help example

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.