Date calculation

Andrée Starå

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

pete gow-hills

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

Andrée Starå

Hi Pete,

Can you share the formula you're using?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

VioletB

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]

Andrée Starå

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.

=[Source Data Cell]@row + [Desired Number of Calendar Days]@row

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!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD