Date functions?

[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

 

[Ron de Bruin]

Hi Jay

CTRL-; will add the Date

 

[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

 

[Ron de Bruin]

Not possible with a worksheet function

 

[Pozzo]

Can you not just enter it as a constant (since, by definition, it won'
update)

 

[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

 

[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.

 

[Frank Kabel]

Hi
have a look at
http://www.mcgimpsey.com/excel/timestamp.html

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi Sid!

Use:
Tools > Addins
Check "Analysis ToolPak"
OK


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[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.