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)
Argument | Description |
---|---|
datepart [required] | Text expression representing the time interval you want to add:
|
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?