Add Date Formula

Micah Turner

Hello Communtiy. I am trying to write a formula that will say if the Start Rent date is greater than 1/1/24 and the Stop Rent Date is Blank add 28 days and enter it in that cell. Can anyone assist with this?

kowal

hi @Micah Turner ,

you will not be able to autofill the Stop Rent Date only if it's blank because you need to use the same formula for entire column. So if you already it fill it by Start Date +28 days it will not be empty.

You need to create extra helping column with formula: =IF(AND([Start Rent Date]@row > DATE(2024, 1, 1), ISBLANK([Stop Rent Date]@row)), [Start Rent Date]@row + 21, [Stop Rent Date]@row)