Evotec

Project

PSWriteOffice

PSWriteOffice is an open-source PowerShell and .NET project with packages, release history, and technical documentation.

View on GitHub Releases Get package
Stars 144
Forks 12
Open issues 16
PowerShell Gallery downloads 150,904
Release v0.2.0
Language: C# Updated: 2026-04-06

API Reference

Cmdlet

Add-OfficeExcelValidationDate

Namespace PSWriteOffice
Inputs
OfficeIMO.Excel.ExcelDocument
Outputs
System.Object
Source
Sources/PSWriteOffice/Cmdlets/Excel/AddOfficeExcelValidationDateCommand.cs:19 Edit on GitHub

Adds a date data validation rule to a worksheet range.

Remarks

Adds a date data validation rule to a worksheet range.

Examples

Authored help example

Restrict values after a date.

PS>


ExcelSheet 'Data' { Add-OfficeExcelValidationDate -Range 'C2:C20' -Operator GreaterThan -Formula1 (Get-Date '2024-01-01') }

Ensures dates in C2:C20 are after 2024-01-01.

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.

Syntax

Add-OfficeExcelValidationDate [-AllowBlank <Boolean>] [-ErrorMessage <String>] [-ErrorTitle <String>] -Formula1 <DateTime> [-Formula2 <Nullable`1>] -Operator <String> [-PassThru] -Range <String> [<CommonParameters>]
#
Parameter set: Context

Parameters

AllowBlank Boolean optionalposition: namedpipeline: False
Allow blank values.
ErrorMessage String optionalposition: namedpipeline: False
Error message shown to the user.
ErrorTitle String optionalposition: namedpipeline: False
Error title shown to the user.
Formula1 DateTime requiredposition: 2pipeline: False
Primary date bound.
Formula2 Nullable`1 optionalposition: namedpipeline: False
Optional secondary date bound.
Operator String requiredposition: 1pipeline: False
Validation operator.
PassThru SwitchParameter optionalposition: namedpipeline: False
Emit the range string after applying validation.
Range String requiredposition: 0pipeline: False
Target range in A1 notation.

Outputs

System.Object

Add-OfficeExcelValidationDate [-AllowBlank <Boolean>] -Document <ExcelDocument> [-ErrorMessage <String>] [-ErrorTitle <String>] -Formula1 <DateTime> [-Formula2 <Nullable`1>] -Operator <String> [-PassThru] -Range <String> [-Sheet <String>] [-SheetIndex <Nullable`1>] [<CommonParameters>]
#
Parameter set: Document

Parameters

AllowBlank Boolean optionalposition: namedpipeline: False
Allow blank values.
Document ExcelDocument requiredposition: namedpipeline: True (ByValue)
Workbook to operate on outside the DSL context.
ErrorMessage String optionalposition: namedpipeline: False
Error message shown to the user.
ErrorTitle String optionalposition: namedpipeline: False
Error title shown to the user.
Formula1 DateTime requiredposition: 2pipeline: False
Primary date bound.
Formula2 Nullable`1 optionalposition: namedpipeline: False
Optional secondary date bound.
Operator String requiredposition: 1pipeline: False
Validation operator.
PassThru SwitchParameter optionalposition: namedpipeline: False
Emit the range string after applying validation.
Range String requiredposition: 0pipeline: False
Target range in A1 notation.
Sheet String optionalposition: namedpipeline: False
Worksheet name when using Document.
SheetIndex Nullable`1 optionalposition: namedpipeline: False
Worksheet index (0-based) when using Document.

Outputs

System.Object