spongeavenger
New Member
- Joined
- Aug 9, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I want to write a formula including =DATEDIF() but this question probably applies to other functions as well. The dates are contained in a column. Of course DATEDIF() requires a start_date and end_date. If the start_date is A2 and the end_date is A100 then my formula is =DATEDIF(A2, A100, "M").
My question is: when new dates/rows are added (e.g. A101, A102, etc.), how can I update the =DATEDIF formula automatically?
My question is: when new dates/rows are added (e.g. A101, A102, etc.), how can I update the =DATEDIF formula automatically?