My job requires reports with multiple activities w/ dates. I have to look through all of the dates and document any time 7 days went by without an activity.
I would like to be able to type all of the dates (about 200 dates) in one list and get a list (or a report) of 7 day, or greater, gaps.
I am an extreme newbie so pardon my ignorance. Thanks
If dates in Col A. Enter this in B2 and drag down
Checks the cell above if > 7 it returns the text >7 otherwise leaves the cell blank=IF(A2-A1>7,">7","")
HTH
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Awesome! Thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks