Hi, I need some help here. Please see attached Spreadsheet.
I have some text in Column A. This text is a drop down from a range Column H. Now i have Date1 in column B and Date 2 in Column C. This Date 2 will always be the same for the particular text in A1. I need a formula to look at text, then find out if Date2 is earlier than Date-1 and return "Repeat", if Date2 is later than Date-1, "First Time", if there is no date or there is simply text in Date2 column, then return "Does not have a date" .
Thanks
Gautam
Bookmarks