Time is an important resource that every company treasures and attempts to convert in a advantage. When picking document management software, take note of a clutterless and user-friendly interface that empowers consumers. DocHub delivers cutting-edge tools to enhance your file managing and transforms your PDF editing into a matter of a single click. Delete Formulas into the Demand For Extension Of Payment Date with DocHub in order to save a lot of time and enhance your productivity.
Make PDF editing an easy and intuitive process that helps save you a lot of valuable time. Easily change your documents and deliver them for signing without the need of looking at third-party options. Focus on relevant tasks and boost your file managing with DocHub starting today.
we need to look up the last payment date invoice1001 has four payments and somehow we need to go through the date column and get the date for the last payment now considering that dates are numbers and what we want is the biggest number in this column based on a condition in this column we can use the max ifs function the max range those are the numbers we highlight the date column comma the criteria range thats all of the invoices comma then for criteria one we have to tell max ifs which invoices we are interested in now close parentheses and i have to come back click back inside the function click on max range because im going to copy this formula and i forgot to hit the f4 key to lock it then i do the same thing for criteria range 2 f4 that criteria is a relative cell reference that we want to move as we copy it down now i can use ctrl enter to put the formula in the cell and keep the cell selected and bam theres our date now i can double click the fill handle with my cross hair