Return HIGHER value with condition

Asked

Viewed 611 times

1

good night.

I have a spreadsheet in NUMBERS (spreadsheet program similar to Excel), because I use Mac and have been used to it for years. Serves me well although I know there is Excel for Mac.

My problem is this:

How to return in the yellow cell the FIRST future date of column B after the date of TODAY (represented there in the figure as 29/1/2019). That is: What is the first future date after the date of TODAY.

There is no way the A column is in ascending or descending order in the current project because it comes to scheduling names in alphabetical order.

The formula needs to identify the FIRST future date based on TODAY.

Someone has the solution?

inserir a descrição da imagem aqui

excel

  • Does this Numbers software have similar functions to Excel? If I give you the answer in Excel it will help you?

  • Good evening! Yes, perfectly. All EXCEL formulas are in NUMBERS.

  • You want to add 1 day to the dates of the first 2nd column or add 1 day to today’s date?

1 answer

2

I used Index, Corresp, Minor, Abs and Today formulas, so be sure to find the corresponding formulas in your program. The result for my spreadsheet is

=ÍNDICE(B2:B10;CORRESP(MENOR(ABS((HOJE()-B2:B10));1);ABS((HOJE()-B2:B10));0);1)

Of course, instead of using the hoje() in the formula you can make a direct reference to the cell D2 in your case.

Detail: This is a matrix formula, so when you finish typing the same one you have to press Ctrl + Shift + Enter (at least in Excel). After this key combination you will see that the formula was involved by { } which represents a matrix. Note what I am saying in the detail below in the formula bar.

inserir a descrição da imagem aqui Contributed Kiwirafael

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.