Creating Dates

[Tim6]

Hi There, 

Based on a date, i would like to create a column that provides semi-monthly dates. 

I.e 

Date starts 01/01/2021

the next date would be + 15 days = 01/15/2021

the next date after that would be +16 days = 01/31/2021

would you be able to assist me. 

Thank you,

[AkimasaKajitani]

Hi @Tim6 

You can use DateTimeAdd expression.

If you would provide the date "2021-01-01", you can output the bellow result by using DateTimeAdd expressions in Formula tool.

The result is as follows.

[atcodedog05]

Hi @Tim6 

Here is a solution if you want next day after as last day of the month since you mentioned semi-monthly.

Workflow:

Hope this helps : )