Sign in to join the conversation:
How do I create a cell formula that calculates a future date from another cell that has a date?
Hi Ammar,
Welcome!
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi there all,
thanks for the advice on the functionality. This will be very useful but what I am seeing is the following message:
"As the sheet admin, you can allow this change. It will not affect the restriction setting."
The formula I am using is in a column that has been configured to be a date and is adding/subtracting an offset in days to/from a date in a second column. Can anyone give me a hint where to find this "restriction" or is this something that I just need to put up with as an administration?
Thanks
Pete
Hi Pete,
Can you share the formula you're using?
Have a fantastic weekend!
Hi,
I am using following formula to create a new due date based on an existing date.
both columns are 'date' columns but I still get #unparseable. can anyone help?
thank you
=[Source Data Cell] + [Desired Number of Calendar Days]
Hi Violet,
Try something like this.
=[Source Data Cell]@row + [Desired Number of Calendar Days]@row
The same version but with the below changes for your and others convenience.
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Hope that helps!
Workflow Consultant / CEO @ WORK BOLD
