Solved Can any one show below formola

May 1, 2013 at 11:10:34
Specs: Windows 7
can anyone describe this formola for me

See More: Can any one show below formola

Report •

May 1, 2013 at 12:03:51
✔ Best Answer
The following came directly from Excel 2010:

'DATE' Syntax: =DATE(year,month,day)
Returns the number that represents the date in Microsoft Excel date-time code.

'INDEX' Syntax: =INDEX(...)
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.

'MATCH' Syntax: =MATCH(lookup_value,lookup_array,match_type)
Returns the relative position of an item in an array that matches a specified value in a specified order.

It appears that the formula you posted is returning a number that represents a date using cell "AC3" as the year, "INDEX({1,2,3,4,5,6,7,8,9,10,11,12},MATCH(AC2,monthNames,0))" as the month and "1" as the day.

It's hard for me to say what Index and match are doing specific to your data since I don't know what that data is, but hopefully Excel's description of each of those functions is helpful.

Law of Logical Argument: Anything is possible if you don't know what you're talking about.

Report •
Related Solutions

Ask Question