Calculating 180 days from specific Date column
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 :/
Best Answer

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.
Answers

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

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

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

Try =[Hire Date] + 180

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

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.

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

@Jordan Ionita I'm glad that finally worked! Don't forget to mark your question as answered.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!