Extract Date - Based Upon Criteria - From Range of Dates

[AlyssaAugust]

I have a question regarding a spreadsheet for tracking vacation benefits for work.

My spreadsheet is setup similar to this:

Column A Column B ... Column AAA
Row 1: Payroll Ending Date
Row 2: Employee Name Dates

Dates before today's payroll date are vacation dates that have been used in the past. Dates after today's payroll date are vacation days available that have not been used, but have an expiration date in them.

I need to report to the employees two pieces of information. 1) the last date taken (so they can verify the last date they took has been accounted for). So, for this I need a formula to give the date closest to, but less than the Payroll Ending Date.

2) I need to report the next date a vacation day will expire. So, similar to the 1st item, I need a formula to give the date closest to, but greater than the Payroll Ending Date.

I've been spinning my wheels all morning, so I thought I'd break down and ask for help Thank you!

 

[CSyx]

AlyssaAugust,

I am a little confused about the format of your spreadsheet...but have you tried using either of the LARGE or SMALL functions?