Go Back

Get Date Associated with Last Entry

Figure 1. of Date Associated with Last Entry in Excel.

In order to determine a calendar date corresponding with the last data entry in our Excel sheet, we can used the Excel LOOKUP Function. This article will step through the process.

Generic Formula

=LOOKUP(2,1/(row<>""),header)

Where row is the total range of cells containing the data entries and header is the range of cells containing the headers for the columns used in our worksheet.

How to use the Excel LOOKUP Function.

We are now going to demonstrate the usage of the Excel LOOKUP Function in the following three simple steps;

  1. Collect and arrange the data values in our Excel sheet. In the example illustrated below, we are working with sales entries along with corresponding calendar dates.

Figure 2. of Sales Records with Calendar Dates.

  1. For us to obtain the date associated with the last entry in our worksheet, we will enter the following formula into the formula bar for cell G2 in the example illustrated below.

=LOOKUP(2,1/(B2:F8<>""),B$1:F$8)

Figure 3. of LOOKUP Function in Excel.

The formula will lookup the specified range of cells containing the calendar entries and automatically return the calendar date associated with the last entry.

  1. Modify and copy the formula above into the other cells in the LAST ENTRY column of our worksheet, to get the desired results.

Figure 4. of Date Associated with Last Entry in Excel.

Note

  • Our LOOKUP value = 2, and the largest value in the LOOKUP range is 1. Hence the LOOKUP Function will match the last 1in our specific cell range.

Instant Connection to an Expert through our Excelchat Service

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Need to make a button that: 'Find last date entry in a column 'Find the next workday from last entry in column' 'Paste value into first empty cell in column with same format'
Solved by M. J. in 16 mins
1. Extract/filter Name, Date, First entry and Last exit times with total hours from a dataset.
Solved by D. D. in 14 mins
I have a problem regarding to Get last entry by month and year
Solved by X. L. in 29 mins

Leave a Comment

avatar