Help! Current Date in a column
This can be done without VBA using the formula
=if(b1="X",now(),"")
where B1 is the cell that you want to chek for an X.
HTH
Ian
"Glynn Furr" wrote:
I am hoping that someone can help me with this.
I have a column that is normally blank in each cell. I place an "X" in a
cell in that column when an event occurs for the Person represented by the
row. What I need is: to have a date column that went the X is placed in the
that cell, the current date is placed in the date column cell for that row.
Can anyone help or point me in the right direction?
Many thanks in advance,
Glynn ..
|