I need some help.
I have removed the names and data to preserve information, however I need to create a function or IF statement that will do the following.
This is what i need...If the dates on (date one) colum fall within 15months of todays date i need it to show up with name and date in (Sheet Date 1)
So lets say (Name One) and the date 8/6/1996 falls with in 15 months of todays date... on (Sheet date 1) I need the name of the person and the date to show up.
Is this at all possable. Im pulling my hair out with arrays n stuff. Thanks