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
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