Enter Today's Date When A Specific Value Is Selected In DropDown

[rich_cirillo]

Hi

Can this be done

1. Can a dropdown list say "Todays Date" and when selected it puts Todays actual date in the cell....IF I select Todays date it actually places 8/5/2013 in the cell
2. If I open up the sheet tomorrow it still says Todays date on the dropdown list but it will place 9/5/2013 in the cell

Thank you

Rich

[princ_wns]

Hi Friend,

Just Paste The Following formula in Cell J3 : =IF(D3="Todays Date",TEXT(TODAY(),"dd-mmm-yyyy"),"")

Regards
Prince

[rich_cirillo]

Thanks princ_wns

That works well but is it possible that when i select the "Todays Date" from the dropdown menu that it actually places the date in the cell where the dropdown option is which is cell D3 instead of J3....i will then copy the formula down the "D" column

Thanks again

Rich

[sdsurzh]

Then you have use control+; (for today date in value format)