How to use any date entered in a cell and outputting in another cell "Date Filled"

  • Thread starter Thread starter drewmacher
  • Start date Start date
D

drewmacher

Hi. What I'm trying to do is if a user puts in a certain date in a cell
in another cell it would reference this in another cell using say an i
statement specifying if that cell = date, print something like "Dat
Filled". e.g. A1 = 15/2/00. A2 = (would use A1 for any date entered t
print a statement such as "Date Filled". A2 would also have an i
statement attached to it already, so it would have to be nested). I
A1 = 14/2/00, it would print the same as A2
 
Hi
not quite sure I understood you. Maybe something like
=IF(A1<>"","Date filled","")
and apply data validation to cell A1 ('Data - Validation) to allow only
dates to be entered in A1
 
Back
Top