Hello,
I have a spreadsheet where Column G is formatted for dates, however, the user may also enter any text. I am looking for a formula with the following conditions:
If Column G33:70 contains a date and Column A is blank, put the message "Please enter an Accounting Period in Column A" in the cell B7, otherwise B7 is blank.
Note that a message is not needed if Column G contains text and Column A is blank.
Thank you!
Bookmarks