View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardy Ardy is offline
external usenet poster
 
Posts: 136
Default If Date Null Show Nothing

Hello All:
I am Using The =MAX(A1:A5) to pick the most recent date from the given
range. The Problem I am having is that if the Range is Null no date I
get the Date 1/0/1900, Is there any way we can have it not show any
dates if the range is null. I had the similar problem with calculating
percentiles and I tried to adopt variations of that to this but not
working

Ardy