Skip to content

Excel EOMONTH and EDATE functions

gcvfi edited this page Apr 22, 2020 · 1 revision

Back to Excel functions | AIQ Commands | Home


Note: Draft content, work in progress, not yet reviewed or verified.


Examples

Test Steps Test Data
open website https://www.google.com/search?q=usa+time
_xl{EOMONTH(TODAY(),0) } as var_date_slno
enter text ${var_date_slno}
_xl{TEXT(DATE(YEAR(${var_date_slno}), MONTH(${var_date_slno}), DAY(${var_date_slno})) , "mm/dd/yyyy")} as var_date
enter text ${var_date}
_xl{ EDATE(TODAY(), 1) } as var_date_slno
enter text ${var_date_slno}
_xl{TEXT(DATE(YEAR(${var_date_slno}), MONTH(${var_date_slno}), DAY(${var_date_slno})) , "mm/dd/yyyy")} as var_date
enter text ${var_date}
_xl{ DAY(TODAY()) } as var_day
enter text ${var_day}
_xl{TEXT(TODAY(), "mm/dd/yy")} as var_date
enter text ${var_date}
wait 1 sec
... ...

See also

Clone this wiki locally