static date

  1. C

    Dynamic Today() in a formula on another cell working but I need it to not change tomorrow or later.

    I'm sure this has been answered as I've read similar post on this forum but none matched what I am doing exactly and I need to get this fixed quickly. I apologize if this is a repeat, but I have a simple formula on a cell that when the value of the cell is not longer empty, or an employee...
  2. R

    Possibly a VBA command needed

    Hello All! I am trying to build a excel sheet that can do the following. When some one selects a yes or no (from the list) in Column B it than copies the Cell E10 and pastes special text/value only into the corresponding row Cell E. Eg click yes on B4 pastespecial the static date and time E4...
  3. R

    Static date auto entry

    Hello Excel World, I have a workbook full of templates and when the workbook is opened I would like for the date field (cell d4) to auto enter a static (one that does not change) into the cell. Can someone please help the code to do this. I can get the date to populate but it changes to the...
  4. C

    Staticdate() designed in 2003 not working in 2010

    Hi everyone. I have designed a spreadsheet in 2003 which uses staticdate in a formula e.g. =IF(C34="y",StaticDate()). It works perfectly fine in Excel 2003 but when I open it in Excel 2010 it returns the current date i.e. the date the spreadsheet is being opened on. When I re-open in in 2003...
  5. N

    Static Date - across several sheets

    <code>Hi, Having searched </code><code>MANY </code><code>previous threads I have finally found the following code that was submitted by phamtom1975 back in Dec 2003 and it works wonderfully, where if 1 is entered into A1 then the current date and time is put into E1. Private Sub...

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