XL.DateAdd function

XL.DateAdd function – Date and time function type – returns a date value containing a date and time value to which a specified time interval has been added.

The XL.Random function helps you to easily add years, months, hours, etc. to the date.

Syntax

=XL.DateAdd(datepart, number, date)

ArgumentDescription
datepart
[required]
Text expression representing the time interval you want to add:
  • Year
  • Quarter
  • Month
  • Hour
  • Minute
  • Second
number
[required]
Number of intervals you want to add.
date
[required]
An expression representing the date and time to which the interval should be added.

Any questions or suggestions?
How can we help?