damian_r_Home
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 231
- Office Version
- 365
- 2007
- Platform
- Windows
Good evening all.
I have a sheet in which column M has numerous dates in it.
All the dates are in order oldest and the top, newest at the bottom.
However the dates are not manually entered, they are there based on an IF formula which is =IF(C6="N",A6,"") which will obviously leave a lot of cells without a date value in them.
In cell M5 I'm looking for a formula that will scan all the dates in range M6:M1000 and to display the largest number of days that occurs between the dates.....
Hope this makes sense
stay safe
D
I have a sheet in which column M has numerous dates in it.
All the dates are in order oldest and the top, newest at the bottom.
However the dates are not manually entered, they are there based on an IF formula which is =IF(C6="N",A6,"") which will obviously leave a lot of cells without a date value in them.
In cell M5 I'm looking for a formula that will scan all the dates in range M6:M1000 and to display the largest number of days that occurs between the dates.....
Hope this makes sense
stay safe
D