I need to capture a cell and put it on another sheet only when it's a date. Is there a way where I can say that =IF('Master Intake Tracker'!K7="Any Date",'Master Intake Tracker'!I7,"")........any way to do this? And also not capture if cell is unanswered? so if the cell is blank it won't capture and sent to another sheet?
Alternatively, you could use the following userdefined function (which simply makes a VBA function available on the spreadsheet:
This function will return TRUE if a cell has a regular dateformatted Excel value or if it has a string that specifies a date (such as "November 3, 2012"). Usage would be simple:



Dates are simply formatted numbers in Excel  difficult to explicitly check for a date, but you can probably just do this:
that follows the logic of the formula in your question  if you want to return the date itself then change to:



Use Assuming your test cell is A1, you can use this formula: Customized to your example: 


Your question is somewhat vague and ambiguous. If you mean “[is it] a date, stored as a date (in Excel’s numerical representation of dates)?”, then
might be a good place to start. 

