Function Question - is it possible to ....

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

I have a couple of questions relating to a template I am making that
calculates court due dates from a Pre-Trial Order.
The language, which is similar for all the entries, is something like this:

Depositions - if to be read or presented at trial, the Party
offering the deposition shall designate the parts to be offered not later
than 21 days prior to commencement of the trial session or 10 days before
the Trial Management Conference, which ever is earlier.

Is there a formula I can use that utilizes the two dates referenced (Trial
and Trial Management Conference), subtract the appropriate specified "time
before" and then compare to see which is earlier? There are times when
there is no Trial Management Conference set, does that affect the formula?

Any help would be greatly appreciated.

Also, the way I have it right now is separated into two columns. One with
TMC due dates and the other with Trial dates. Is there a way to have the
cell appear empty if there is no TMC date to reference to?
 
Hi!

With trial date in A1 and Trial Management Conference in B1:

Depositions Date:
=MIN(A1-21,IF(B1="",A1-21,B1-10))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thank you so much. This will make my template look much neater.

Marcia Libby
 
Hi Marcia!

Thanks for thanks. This was a modified version of the normal approach
which is:

=IF(OR(A1="",B1=""),"",YourFormula)
or if you have a lot of cells that need to be filled:
=IF(COUNTA(A1:D1)<4,"",YourFormula)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top