How to create a future date based on a date in another column?

Hi,

I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days.

Thanks!

Keren

Find more posts tagged with

Sheets

Finance

Formulas

Support

Solution Center

Community Platform

Product Development

Project Management

Comments

Andrée Starå

Hi Keren,

Try something like this.

=[Date of Deposit]@row + 84

The same version but with the below changes for your and others convenience.

=[Date of Deposit]@row + 84

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

The above solution is the simplest method.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

springwud

Hi Andrée,

Thank you so much for your reply! Unfortunately, it didn't work for me and just turned the year into 1984. Is there anything else you think might work?

I'm new to this so I appreciate your help!

Best,

Keren

Andrée Starå

Happy to help!

What date do you have in the date cell? Is the column formatted as a date type column?

springwud

Hi Andrée,

The Date format for the Date of Deposit is 06/10/19. Each row has a different date. I would like the Estimated Completion Date column to have the same format. Both columns are formatted to Date - they currently are checked off as restrict to date format only. Should that change?

Thanks!

Keren

Andrée Starå

That's strange!

Can you paste the formula?

Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

springwud

Hi Andrée,

Attached is a screenshot of what it looks like...let me know if this helps?

Thanks again!!!

Keren

Screen Shot 2019-07-25 at 11.13.55 AM.png

Andrée Starå

Happy to help!

Can you share the formula you're using as well? If you click on one of the dates in the Date of Deposit column is the date picker at that date when you open it?

springwud

Hi Andrée,

The last formula I tried was the one you sent....not sure what you mean by date picker - would you mind elaborating?

Thanks!!!

Keren

Andrée Starå

It seems like your columns aren't formatted as date type columns.

Can you double-check?

springwud

Hi Andrée,

Thanks so much - you were right that one of the columns wasn't formatted correctly. Which formula do you now suggest I use given the sent snapshot of the columns?

Best,

Keren

Andrée Starå

Happy to help!

Try the one I sent before.

Did it work?

springwud

It worked! Thank you so much for your help and patience!

Andrée Starå

Excellent!

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…