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 
