# Calculating 180 days from specific Date column

Options
✭✭✭✭

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 :/

Tags:

• ✭✭✭
Options

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.

• ✭✭✭
edited 03/03/22
Options

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

• ✭✭✭✭
Options

@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?

• ✭✭✭
Options

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

• ✭✭✭✭
Options
• ✭✭✭
Options

Try =[Hire Date] + 180

• ✭✭✭✭
Options

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

• ✭✭✭
Options

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.

• ✭✭✭✭
Options

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

• ✭✭✭
edited 03/03/22
Options