Date Row Funtions in Excel

Interesting Microsoft Excel Formula Based on Date and Row Functions
A user who visited our website has this problem to solve:
She has names in column A and end contract dates in column B. Now she wishes to find out the people whose end contract dates are earlier than July 1, 2012. She wishes to show the name and the number of data out of the total data, for example, ‘Sam, 1 of 4’.
At first glance the problem appears to be a very simple one but once you start looking for a solution you realize that it has thrown many interesting questions. We solve the problem using the ‘IF’ function combined with the date, concatenate and row functions to get the final desired result.
Watch the video to see how the solution is implemented:

Leave a Reply

Your email address will not be published. Required fields are marked *