Professor Excel

Comments 1

  1. Marie Nguyen

    I set up my worksheet where the dates are auto-populated when an initials is entered. The next day, I put my cursor on the initial field and click on the Save and it automatically change the date to today’s date. As an example I using the following formula:

    =IF(BK32″”,IF(AND(BN32″”,CELL(“address”)=ADDRESS(ROW(BK32),COLUMN(BK32))),NOW(),IF(CELL(“address”)ADDRESS(ROW(BK32),COLUMN(BK32)),BN32,NOW())),””)
    Also enable the ‘Iterative Calculation’ to automate the date.

    Can you please help. Why the date is changing on spreadsheet, when the cursor is left on the initial field after exiting. Please advise.

Leave a comment

%d bloggers like this: