Log in

View Full Version : How to identify a month in a worksheet and match it with a month on another worksheet


ajitkp70
Oct 4, 2012, 12:25 PM
I want to put in a value in a cell by identifying only the month from a given date on one excel worksheet and match it with only a month from a given date on another excel worksheet

ebaines
Oct 4, 2012, 01:05 PM
The function month(A1) returns the month of a date in cell A1, as a number 1 through 12. So if the cell A1 has the date Feb 3 2009, then month(A1) returns the number 2.

If you want to match data between separate worksheets you need to prepend the worksheet name. So month(sheet1!A1) returns the month of the date contaned in cell A1 of worksheet "sheet1."