date changed

  1. D

    Date Change Only When New Data Is Entered

    I'm sure this has been asked a million times but I am in a time crush and have to figure this out ASAP! This board has been a great help in stumbling my way through Excel so I hope that someone can help me out with this conundrum! I have a spreadsheet that we use to keep track of quotes from...
  2. B

    changuing Date format

    Need some help with this... There is an sales management system in the company I work for, from were I have to get a report and export it to excel to manipulate. This report shows dates in cells with in the format YYYYMMDD (example cell A1 = 20100611). I want to know if there is a formula or...
  3. P

    Last Changed Date for a given sheet

    Hi, I've created a workbook for the CEO with multiple sheets. Each sheet is for a seperate department. The CEO has a summary sheet that pulls through data from the department sheets. So far so good. The CEO now wants to know when each sheet was last updated, so that he can see if all the...

Watch MrExcel Video

This Week's Hot Topics

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
Top