Static Date

H

howardk

I'm trying to automatically populate a cell with a static date when
predetermined criteria has been met in another cell. The problem I’
experiencing is that each time the worksheet is opened the date i
refreshing to today’s date. Detailed is an example of the formula I’
using.

=IF(A4="Y",(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))),""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Function needed 1
Excel Message box with days of month & date. 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Location Oriented Formula 1
Excel Vba to change displayed year automatically. 14
date help 1
First Half / Second Half Month Budget 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Top