Re: Static Date

[Frank Kabel]

Hi
See: http://www.mcgimpsey.com/excel/timestamp.html

--
Regards
Frank Kabel
Frankfurt, Germany

> I'm trying to automatically populate a cell with a static date when a
> predetermined criteria has been met in another cell. The problem I’m
> experiencing is that each time the worksheet is opened the date is
> refreshing to today’s date. Detailed is an example of the formula I’m
> using.
>
> =IF(A4="Y",(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))),"")
>
>
> ---
> Message posted from http://www.ExcelForum.com/