Column A lists dates (mm/dd/yyyy), but some cells = "Pending".
I'd like Column B to list the dates in Column A minus 1 day. So right now in Column B, I've put "=(A1)-1" but the cells in Column A that = "Pending" are showing up in Column B as "#VALUE!".
How can I make it so Column B lists the new date (Column A minus 1 day) and/or "Pending"?
Thanks.
Bookmarks