I have a worksheet in which a date is entered in Column B, after which the following formula is automatically entered into Column A (same row) to display the day of the week corresponding to the date in Column B:
Previously, I set up the worksheet to automatically enter these formulas in Column A, but I don't recall how I did it, nor can I find anything in the code that would accomplish this.
Here are a couple of additional pieces of relevant information:
When a date is entered into (or deleted from) Column B, the following message displays briefly in the status bar at the bottom of the page:
Any ideas or suggestions?
=UPPER(TEXT(B1,"ddd"))
When a date has not yet been entered into Column B, the cell next to it in Column A is blank, and when the cursor is in a blank Column A cell, no formula is visible in the formula bar.
Previously, I set up the worksheet to automatically enter these formulas in Column A, but I don't recall how I did it, nor can I find anything in the code that would accomplish this.
Here are a couple of additional pieces of relevant information:
When a date is entered into (or deleted from) Column B, the following message displays briefly in the status bar at the bottom of the page:
Calculating: (2 processor(s)); 0%
Deleting a date from Column B does not delete the formula from Column A.
Any ideas or suggestions?