Could somebody please give me some guidance on creating a formula please.
What I am trying to achieve is to push a date by a number a weeks. The first column contains the date, the second column contains the number based on weeks, the third column is where i require the new date based on the previous two columns.
Example
First column = 01/01/2022
Second column = 3 (number of weeks)
Third column = 22/01/2022
Can this be achieved? I have tried ADD_DAYS to ensure that works, although when a item is blank it will show some random date in the third column. If zero is entered it will mirror the date in the first column. Ideally if the second column is blank I would like the third column to be blank. I then tried ADD_WEEKS but that came back as unrecognized. So I presume this is not a function.
Hi Wayne
there are a couple of ways to do this
you can add days or workdays
Workdays will skip weekend
Workdays formula - (you would just need to replace the column names for your column’s)
I have also set if statements if date or number of days hasn’t been filled in (it will warn)
IF({1st Date}=“”,“SET DATE”,IF({Days to push out by}<1,“SET NO OF DAYS”,FORMAT_DATE(WORKDAY({1st Date},{Days to push out by}))))
Using the days method instead (to include weekends) - again just change column names
IF({1st Date}=“”,“SET DATE”,IF({Days to push out by}<1,“SET NO OF DAYS”,FORMAT_DATE(ADD_DAYS({1st Date},{Days to push out by}))))
If there is anything else you need assistance with please let me know
Many thanks in advance
Dan