Calculating 180 days from specific Date column

Jordan Ionita · 03/03/22

Hi,

I am trying to calculate 180 days from a date column titled "Hire Date". What does that formula look like? I have tried:

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

=[Hire Date] + [180]

=[Hire Date] + [180 Days]

None of those work :/

Summer · 03/03/22

It's been a long day for me. I see the error.

We were not telling the formula which cell.

=[Hire Date]@row + 180

We previously had just [Hire Date] which told the formula which column but neglected to specify the cell.

@row tells the formula which cell to look at. So we want it to look at the Hire Date column and the cell in the same row as the formula.

Summer · 03/03/22

When you say none of the formulas work. What is the error message you're getting?

Be sure both the column with the formula and the Source Data cell are formatted as Date columns.

Then your logic of =[Source Data Cell] + [Desired Number of Calendar Days] should work

Jordan Ionita · 03/03/22

@Summer I am getting the #unparseable error

In place of source data cell, should I be putting hire date, since that is the cell I am wanting the data to pull from? Am I missing quotes anywhere?

Summer · 03/03/22

@Jordan Ionita Please provide the actual formula you're using

Jordan Ionita · 03/03/22

Summer · 03/03/22

Try =[Hire Date] + 180

Jordan Ionita · 03/03/22

@Summer Unfortunately, I still get the same error....

Summer · 03/03/22

It's been a long day for me. I see the error.

We were not telling the formula which cell.

=[Hire Date]@row + 180

We previously had just [Hire Date] which told the formula which column but neglected to specify the cell.

@row tells the formula which cell to look at. So we want it to look at the Hire Date column and the cell in the same row as the formula.

Jordan Ionita · 03/03/22

Hahahah that worked!! I thought it would be something like that, but was blanking out as well. Thank you so so much! :)

Summer · 03/03/22

@Jordan Ionita I'm glad that finally worked! Don't forget to mark your question as answered.

Best Answer