Interesting Microsoft Excel Formula Based on Date and Row Functions

Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010


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 exampple, '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:

Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010