calculating number of days

Nick Caputo

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.

Ken Armstrong

Are you using a duration column in your sheet?

Nick Caputo

Ken,

Sorry for the delay in responding

No I am not utilizing duration because in this instance the goal is to calculate the difference between dates in subsequent rows. More specifically. the idea is to utilize a form to track the duration of when a fleet vehicle is placed out of service and , ideally reflect on a dashboard the duration that is took to get it back in service