To Do List

[joes1945]

I have a very simple To Do sheet. Cells B1-B40 are for the date the task is entered and Cells C1-C40 are for tasks. I would like the date cell in Column B to be blank until a task is entered in the adjacent cell in Column C, at which time it changes to today's date. Then I would like the date to remain unchanged until the task is removed or changed. If the task is cleared, the date cell again becomes blank and the cells are reusable for another task. I know that this requires VB code, but I have no idea where to begin. Sounds like it should be simple, but I've driven myself crazy trying to figure it out.

 

[Iridium]

Shouldn't need VBA - try something on the lines of

B2=IF(ISBLANK(C2),"",TEXT(TODAY(),"dd-mm-yy"))
This message was edited by Chris Chattin on 2002-11-05 06:48

 

[joes1945]

Chris,
Thanks for the reply. Maybe I am doing something wrong, but I can't get that code to work. I also don't want the entry date to change when the day of the month changes. It should remain the entry date until the task is deleted or edited.