calculating number of days
Need help trying to calculate number of days for my project so it will auto-update each time a row is added
The idea is to calculate the difference in days between, in this example Date row 2 and row 1 in a different column (days). I was able to get it to work utilizing =NETDAYS(Date2,Date@row) formula however when I try to convert to a column formula it returns a syntax error because, I believe I am looking up a specific cell. I need this to work in a column formula to allow subsequent updates to auto calculate difference in days. Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!