01/01/1900
 

I run a daily spreadsheet that shows the date inventory for multiple clients
if we have no inventory for that client the date is replaced with *** at the
bottom i have a formula =MIN(I3:I20,I23:I24) to choose the oldest date within
the cell range. but if there is no inventory and all the cells are *** this
formula spits out 01/01/1900 is there any way to make it show *** as a result
if there are no dates? i have been trying to figure this out for a while but
cant get it. i have tried multiple formulas using the IF command but cant get
it to work. any help anyone can provide would be greatly appreciated. Thank
you

01/01/1900
 

=IF(MIN(I3:I20,I23:I24)=0,"***",MIN(I3:I20:I23:I24 ))

Note also that the date you see returned should be 01/00/1900 NOT 01/01/1900

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"excel fool" wrote:

I run a daily spreadsheet that shows the date inventory for multiple clients
if we have no inventory for that client the date is replaced with *** at the
bottom i have a formula =MIN(I3:I20,I23:I24) to choose the oldest date within
the cell range. but if there is no inventory and all the cells are *** this
formula spits out 01/01/1900 is there any way to make it show *** as a result
if there are no dates? i have been trying to figure this out for a while but
cant get it. i have tried multiple formulas using the IF command but cant get
it to work. any help anyone can provide would be greatly appreciated. Thank
you

01/01/1900
 

thank you dave... i have been trying to get that to work for a month. i just
put the formula in and it worked. my mistake is where you put the "0" i was
putting "01/00/1900" and it didn't work. thank you again

"Dave F" wrote:

=IF(MIN(I3:I20,I23:I24)=0,"***",MIN(I3:I20:I23:I24 ))

Note also that the date you see returned should be 01/00/1900 NOT 01/01/1900

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"excel fool" wrote:

I run a daily spreadsheet that shows the date inventory for multiple clients
if we have no inventory for that client the date is replaced with *** at the
bottom i have a formula =MIN(I3:I20,I23:I24) to choose the oldest date within
the cell range. but if there is no inventory and all the cells are *** this
formula spits out 01/01/1900 is there any way to make it show *** as a result
if there are no dates? i have been trying to figure this out for a while but
cant get it. i have tried multiple formulas using the IF command but cant get
it to work. any help anyone can provide would be greatly appreciated. Thank
you

01/01/1900
 

I'd look for a number anywhere in that range:

=IF(COUNT(I3:I20,I23:I24)=0,"***",MIN(I3:I20:I23:I 24))



excel fool wrote:

I run a daily spreadsheet that shows the date inventory for multiple clients
if we have no inventory for that client the date is replaced with *** at the
bottom i have a formula =MIN(I3:I20,I23:I24) to choose the oldest date within
the cell range. but if there is no inventory and all the cells are *** this
formula spits out 01/01/1900 is there any way to make it show *** as a result
if there are no dates? i have been trying to figure this out for a while but
cant get it. i have tried multiple formulas using the IF command but cant get
it to work. any help anyone can provide would be greatly appreciated. Thank
you

--

Dave Peterson