date changes

  1. T

    Inserting Dates based on Cell changes and Selection criteria of Status

    Hello Experts, Seeking out for a code : Criteria : 1) When program name is type ( as long as it is a text) automated date with time should be inserted in column "Date Received". 2) On status there is few items in format of drop down list. Every time a particular status is selected then...
  2. A

    How can I convert a date (year) to include a specific day and month?

    I have a column of dates that are just the year A1 =1992 A2 = 1993 A3 =1999, etc) I need to convert each of these cells to read B1 = 12/31/1992 B2 = 12/31/1993, B3 = 12/31/1999, etc)

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top