bsmothers13
New Member
- Joined
- Jan 22, 2015
- Messages
- 1
I have different dates in column A, names in column B and a product I column C. Is there a formula that will add 7 days to the most recent date for a given name that next time that name is entered if a certain product was entered?
Column A Column B Column C
1/1/2015 John Widget
1/1/2015 Sue Widget
1/1/2015 Mark Widget
John Widget
I would like the blank cell to auto fill the most recent date plus 7 by John's name if widget is entered into column c. If not widget than it can be blank.
Column A Column B Column C
1/1/2015 John Widget
1/1/2015 Sue Widget
1/1/2015 Mark Widget
John Widget
I would like the blank cell to auto fill the most recent date plus 7 by John's name if widget is entered into column c. If not widget than it can be blank.
Last edited:
