Date formula

Help I want to Make a date/time column when it’s empty then it filled with date/time(from other date/time column+1day (wtih specific time of 12.00AM)

so its like
column 1
1/01/2020 07.00.00 AM

then the column I want if emptie will have column 1 + 1 day
1/02/2020 but i want the time always says 12.00.00 AM

Maybe you can use below in an app formula:

IFS(ISBLANK([ColumnYouWant]), DATETIME(DATE([Column 1])+1) )

1 Like

For reference:





3 Likes

Thank you so much Mate :heart::grin:

1 Like

Thank you steve

1 Like