Conditional formula help
Here's what I need to do: One column (D2) in my spreadsheet has the coverage
dates of periodicals . I need to come up with the formula that would insert
"Current" into a new column if the coverage date cell has any of the
following words: present, days, or months. If the coverage date does not
have any of those three words, I want a blank cell. Any help would be muchly
appreciated!
|