Need cells to populate with text when I add text to a 3rd cell [Closed]

Registration date
Monday September 12, 2016
Last seen
September 12, 2016

Don't know if this is possible, I have searched online in various excell sites including excel sites from office.

What I want to do is... Have current date populate Cell C# and the text "Joined" populate Cell E# if I add text "y" in Cell D#.

I already have excel set up so that the current date appears in C# if text "y" is entered into cell D#... If D# is blank then text "Not Posted" populates Cells C#....

Does that make sense?

Thanks for any help

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!