Populate current days date after Picking a option from drop down list

[soicy23]

I am new to excel so I am trying to have a date auto populate when a item is picked from a drop down list.

For Example

B5 from drop down list picked Completed.
P5 to auto populate with todays date.

[mikeTRON]

Welcome to the forum.

So you likely don't want a LIVE formula to be todays date, because when you open the file tomorrow, it will be tomorrows date etc etc.
IF you DO want that then the formula is rather simple as

Please Login or Register  to view this content.

If you wanted a static date value you CAN have a vba script automatically populate the cell for you.

[mikeTRON]

Please Login or Register  to view this content.

This code would do what you wanted if you put it in the WORKSHEET.

[soicy23]

Awesome thank you so much for that.

Would it be possible to have the date be permanent if i change the value in b5 since it is a drop down with multiple selection options?

[mikeTRON]

Are you asking if it would be possible for the date to be permanent with a formula? No you cannot drop in a value from a formula. A formula is always live unless you manually override it OR use something like the VBA I posted above.