On 2002-08-30 11:03, LoriD wrote:
No, not the same cell. I have a spreadsheet that a user must update daily. I expect it to get lengthy, and I just want to automatically fill in the day of the week (required) when they open the workbook and enter the date. I don't want to extend the formula all through the spreadsheet, because it already takes forever to open a simple file on our network here. So, when a user opens the workbook and enters his date in column A, I want a macro (or function???) to find the row he's entering data in, and update the cell in columnB with
=text(A250,"mmmm")