Hi guys,
I need a quick way to find rows where there is a 1 year lapse in "Created Date" but specific to the account name. In the example below, I have data for the 26DotTwo account, however, the master file I'm working with has hundreds of accounts. Is there any sort of IF combo formula that can be used to help highlight this?
The last row is the date we first engaged with this account, and above it are additional dates we worked with them. It's all sorted so the most recent date is shown at the top, and the oldest date at the bottom. What i'm trying to find are dates where there is a gap of 1 year or more.
For example, the 3rd to last row would be an example of this. We worked with them on 4/1/2013 where previously we last worked with them on 9/1/2010 which is almost a 3 year gap.
Does that make sense? Any help to automate this would be greatly appreciated! Thanks!
I need a quick way to find rows where there is a 1 year lapse in "Created Date" but specific to the account name. In the example below, I have data for the 26DotTwo account, however, the master file I'm working with has hundreds of accounts. Is there any sort of IF combo formula that can be used to help highlight this?
The last row is the date we first engaged with this account, and above it are additional dates we worked with them. It's all sorted so the most recent date is shown at the top, and the oldest date at the bottom. What i'm trying to find are dates where there is a gap of 1 year or more.
For example, the 3rd to last row would be an example of this. We worked with them on 4/1/2013 where previously we last worked with them on 9/1/2010 which is almost a 3 year gap.
Does that make sense? Any help to automate this would be greatly appreciated! Thanks!
Account Name | Created Date |
26 Dot Two | 3/4/2015 |
26 Dot Two | 1/27/2015 |
26 Dot Two | 12/31/2014 |
26 Dot Two | 12/4/2014 |
26 Dot Two | 10/14/2014 |
26 Dot Two | 9/17/2014 |
26 Dot Two | 8/19/2014 |
26 Dot Two | 10/8/2013 |
26 Dot Two | 8/5/2013 |
26 Dot Two | 7/24/2013 |
26 Dot Two | 5/28/2013 |
26 Dot Two | 4/1/2013 |
26 Dot Two | 9/1/2010 |
26 Dot Two | 8/30/2010 |