date array lookup

  1. G

    Date Look Up Formula

    I need help coming up with a formula which will pick up a date from a heading row if the rows below has a zero. For example I have a spreadsheet with dates as the main heading and below i have names of resources with forecasted hours. 1/1 1/2 1/3 1/4 1/5 1/6...
  2. K

    Count Holidays, Country Wise Monthly

    Hi Frnds, i am working on the file where in need to Count holidays for Each country for the given Month in a particular year..!! i have tried with Countifs function but its not working Thanks & Regards Kumar
  3. V

    find date interval and lookup value

    i have compile a table that would determine the value im looking for, please see below: A || B || C || D || E || F 1 || Start Date ||End Date || Debit Month 2 || 19-Apr || 15-May || MonthA 3 || 17-May || 19-Jun...

Some videos you may like

This Week's Hot Topics