Date functions?

J

Jay3253

What function inputs todays date but will not update to the current dat
once you reopen the workbook the next day? I hope that makes sence
 
J

Jay3253

I would like to have a function that adds a date in an if statement bu
will not update if I close the worksheet and reopen it
 
J

Jay3253

I am too lazy I just want it to put a date in a cell if there is dat
put into another cell. I could put it in as a constant but that woul
require me typing in more than one cell. I know this sounds stupid bu
it is something my boss wants and I am the one who gets stuck trying t
find out how
 
S

Sid

While this is not relevant, does anyone know what happened
to the EOMONTH function that I've been using for years?
Quite valuable, but in Excel 2003 it's gone! Sad.
 
N

Norman Harker

Hi Jay!

To save typing in more than one cell:

Set aside a cell for the date.
Enter today's date in that cell using Ctrl + ;
Then refer to that cell in all your formulas.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
N

Norman Harker

Hi Sid!

Use:
Tools > Addins
Check "Analysis ToolPak"
OK


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
S

Stephen Bye

It sounds like you need a VBA macro that watches for data being entered in
cell 1 and then puts the current date in cell 2.
If you ask in microsoft.pubic.excel.programming I'm sure they can point you
to one.
 
Top