Return the date of the day under an if formula with Excel or VBA

Posted by Celine on Super User See other posts from Super User or by Celine
Published on 2010-02-10T21:09:54Z Indexed on 2010/04/17 15:14 UTC
Read the original article Hit count: 314

Filed under:
|
|
|

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

© Super User or respective owner

Related posts about excel

Related posts about vba