Calculating a Required Date According to Two Criteria in Microsoft Excel

To calculate required date according to two criteria, we will use MIN function along with IF function in Microsoft Excel.

  • MIN function search for minimum value within a range
  • IF function checks define condition is meeting or not

Let’s take an example,

Columns B & C contain test dates and paper deadlines for each of the subjects listed in column A.

A test requires 3 days of preparation and a paper requires 5 days.

image 1

 

For each subject, we want to calculate the earliest date required to start preparing for either a test or a paper.

Follow below given steps:-

  • Write the formula in cell D2
  • =MIN(IF(B2<>””,B2-3,C2-5),IF(C2<>””,C2-5,B2-3))
  • Press Enter
  • The function will calculate the required date

image 2

 

  • To return the all preparation date copy, use the same formula by pressing Ctrl+C and paste in the range D3:D6 by pressing  Ctrl+V

image 3

 

In this way, we can calculate the require according two criteria in Microsoft Excel.

 

image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube