Closest Date

using the function VLOOKUP() you can search in a table column

Find in the table the greatest date that is less than or equal to a specified (nearest bottom). And of all the dates in the table will take into account only those that relate to a particular product (condition). The list can be primary.

suppose you have a list of certain events, such as holidays. Find the nearest event, which hasn't happened yet.

Let there be range with dates. Find date in this range which is closest to a given. The solution to this problem is similar to solution described in the article Find the NUMBERS closest to a given.

Determine the date of the next Saturday before a specified day. Ie if today 25.11.2014 (Tuesday), the nearest last Saturday - 22.11.2014. Also define the date nearest Saturday after a specified day, and just date is the nearest Saturday.

Suppose that the bill for the products you need to put only on working days, despite the delivery date. Write a formula that determines: if the delivery date falls on a weekend or holiday, then the invoice date is the following Monday (or last Friday). The decision also takes into account working Saturdays.

Suppose that the bill for the products you need to put only on working days, despite the delivery date. Write a formula that determines: if the delivery date falls on a weekend, then the invoice date is the following Monday (or last Friday).