Melissa_S_Cohen
New Member
- Joined
- Dec 1, 2016
- Messages
- 17
Right now I have a formula that takes a date, adds a specific number to it based on a Vlookup of data from a different cell in the row, and outputs the new date. It works perfectly, EXCEPT when there are blank dates - then it tries to add based on the Vlookup and gives me some wonky-looking dates (like 01/30/1900). How can I get Excel to ignore the blanks?
My formula is: =J4+(VLOOKUP(C:C,Terms!B:C,2,0))
My formula is: =J4+(VLOOKUP(C:C,Terms!B:C,2,0))