If cell contains Today() return adjacent cell with Text

[whoosh]

Is it possible to create a code to check cells in column O for today's date, if yes clear cell and write text to the adjacent cell in column P?

[David A Coop]

I am not clear about what you are trying to achieve!

In cell P3, =IF(O3=TODAY(),"A","") will cause the letter A to appear in P3, but tomorrow, it will no longer be true, so the cell will be blank.

However, I expect you want a macro. This can be accomplished, but I need more information!

1. What do you want the text to be?
2. What range do you want to work on?
3. How often do you do this?

Looking at the example you posted, you would end up with O3,O4,O5,O9 and O14 all blank with something in the adjacent column.
I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[davesexcel]

You were on the right track.

Please Login or Register  to view this content.

[whoosh]

Hi David, thanks for the input.
For me, it will be a growing workbook.
The dates are entered at different time frame. What I would like to achieve is when the dates in column O equals to current date, the cell will be cleared and return text in adjacent cell and stay there till further changes made manually. To answer your questions:

[1] What do you want the text to be?
To be finalised, could be "immediate", "overdue", etc

[2] What range do you want to work on?
In column O, range (O3: O5000)

[3] How often do you do this?
Daily

My apology. O3,O4,O5,O9 and O14 should be filled with text.

Thanks

[whoosh]

You were on the right track.

Please Login or Register  to view this content.

Dave, thanks for the code. It WORKS!

Thanks