How do I add days to an existing date?

I have read through this community about the same question, however, the solutions haven't seemed to work for me. I'm working on a Debt Snowball sheet to calculate and estimate when my bills will be paid off. I can use EITHER the Months or Days column from the DATE column. For example - need the formula to add 8 months (or 247 days) to 11/3/23.

My DATE column is set up with the date and is not text or manually inputted.

Find more posts tagged with

Formulas

Accepted answers

Nick Korna

Hi @Jenna P,

If your DATE and Paid off by (est.) columns are both set to date then in the latter put the following formula:

=Date@row + [Days rounded up]@row

You will need to copy/paste the date into the other rows for this to work, but you can then convert it to a column formula.

Alternatively:

=Date$1 + [Days rounded up]@row

(change the 1 for the row number of your date). Here you can't convert to a column formula, but you can copy/paste or drag it down.

Pick whichever option you prefer! 🙂

Hope this helps, if there are any problems/questions then just post!

All comments

Nick Korna

Hi @Jenna P,

If your DATE and Paid off by (est.) columns are both set to date then in the latter put the following formula:

=Date@row + [Days rounded up]@row

You will need to copy/paste the date into the other rows for this to work, but you can then convert it to a column formula.

Alternatively:

=Date$1 + [Days rounded up]@row

(change the 1 for the row number of your date). Here you can't convert to a column formula, but you can copy/paste or drag it down.

Pick whichever option you prefer! 🙂

Hope this helps, if there are any problems/questions then just post!

Jenna P

Thank you @Nick Korna This worked!! I didn't have my Paid Off By column set to Date.

dhall

Hey I just want to leave a comment that if you have a formula to calculate a number of days, make sure the numbers are not in quotes. Here's an example of what I ran into.

Formula:

=IF(CONTAINS("Fundamental", [LP Name]@row), "270", "90")

Result:

I would get "270" as my field if it matched the IF(CONTAINS condition. Sounds good, right? Wrong. It treats it as a string of text and not an integer. So when I tried to do the above solution and adding my date column to my number column, I would get something like this:

10/08/23270. It just appended the 270 to the end of the date. To fix it, I had to remove the quotes, so my formula looked like this:

=IF(CONTAINS("Fundamental", [LP Name]@row), 270, 90)

Rookie mistake, but just wanted to put that on this thread in case anyone else runs into the issue I did!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.