Networkdays formula syntax error
I used the AI formula builder to create a formula to calculate the number weeks (weeks out) between a launch date and milestone dates. I want the weeks out to always be positive. When I try to convert the provided formula, which works in the cell I place it in, I get a syntax error. I can't figure out the error.
Best Answer
-
Your formula is referencing a specific row using [Date]72 - this means the value in the Date column on row 72.
You cannot reference a specific cell in a column formula. If you make this a cell formula, it should work.
Answers
-
Your formula is referencing a specific row using [Date]72 - this means the value in the Date column on row 72.
You cannot reference a specific cell in a column formula. If you make this a cell formula, it should work.
-
Ok so I added another column Launch Date and copied the same date on each row. It now is allowing the formula to be converted to a column formula now that I am referencing the date@row. Thanks for the help.
=IFERROR(ABS(NETWORKDAYS([Launch Date]@row, [Milestone Date]@row) / 7), "")
-
Great news @PDunn
I know it is working now and you might not want to mess with it, but if the launch date is the same for every single row and you don't want to have that extra column, you could make launch date a field on the sheet summary and then reference that in your column formula. See
if you are interested.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!