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

[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)