Return the date of the day under an if formula with Excel or VBA
- by Celine
I have two columns A and B and many lines with some specific tasks to be done. In column B, I have a drop-down list with the name of people who are scheduled for the task . And in column A, I want the date of the day the person signed off the task.
What should I do in VBA or in Excel so that, for example, when somebody signs off a task in the cell B11, A11 returns me the date of the day.
I have used the formula below in A11
=if (B11<"", today(),"") but everytime i open the file the date is updated. So it doesn't allow me to keep track of everybody's work.
I tried with vba but couldn't write a function that gives me the right answer.
i'm pretty new at vba so i'm sorry if my question sounds stupid