Updating date to show next payroll date

With D1 is today' date

B1:B10 contain payroll dates (ascending order):

=LOOKUP(D1,B1:B9,B2:B10)

...or

=INDEX($A$1:$A$10,MATCH($D$1,$B$1:$B$10,1))
to return the number from column A


=INDEX($B$1:$B$10,MATCH($D$1,$B$1:$B$10,1))
to return the date

=index($b$1:$b$30, match(d1,$b$1:$b$30)+1)

Does this help?

Please Login or Register  to view this content.

Wow I was slow on that one.

I was even slower.. I forgot to add the 1.

Here's another one...

Data Range

	A	B	C	D	E
1	Pay Dates	------	------	Today	Pay Day
2	2-Jan-15			24-Jul-15	31-Jul-15
3	16-Jan-15
4	30-Jan-15
5	13-Feb-15
6	27-Feb-15
7	13-Mar-15
8	27-Mar-15
9	10-Apr-15
10	24-Apr-15
11	8-May-15
12	22-May-15
13	5-Jun-15
14	19-Jun-15
15	3-Jul-15
16	17-Jul-15
17	31-Jul-15
18	14-Aug-15
19	28-Aug-15
20	11-Sep-15

This array formula** entered in E2:

=MIN(IF(A2:A20>=D2,A2:A20))

Format as Date

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.