Forum Discussion
Help with constructing avg. waitlist times using datedif function
The DATEDIF formula results in a text string; that is useful for display purposes but you cannot calculate an average of text values.
Add a column with the simple formula =E2-D2. Format the cell with the formula as General and fill it down. It shows the wait time in days.
You can then create a pivot table based on the data.
Add the apartment type to the Rows area and the new column to the Values area. By default, Excel will sum the wait times, but you can change that to average in the Value Field Options dialog.
The DATEDIF formula results in a text string; that is useful for display purposes but you cannot calculate an average of text values.
Add a column with the simple formula =E2-D2. Format the cell with the formula as General and fill it down. It shows the wait time in days.
You can then create a pivot table based on the data.
Add the apartment type to the Rows area and the new column to the Values area. By default, Excel will sum the wait times, but you can change that to average in the Value Field Options dialog.
Sorry, missed your post
No problem!
Thank you both for your help - this is exactly what I needed to know 🙂
