Example of formula:
Sheet1 A1=DATE(Sheet2!H6,Sheet2!H5,1)
Sheet 2 H6=2016 (or any given year I need to work with)
Sheet 2 H5=2 (or any given month I need to work with)
Issue:
I have the formula copied down 31 lines, I do not want the date populated if it is outside the month on "sheet 2 H5".
Needed:
How do I get the cells to be blank or have N/A for the dates outside the month range from sheet 2 cell H5?
Sheet1 A1=DATE(Sheet2!H6,Sheet2!H5,1)
Sheet 2 H6=2016 (or any given year I need to work with)
Sheet 2 H5=2 (or any given month I need to work with)
Issue:
I have the formula copied down 31 lines, I do not want the date populated if it is outside the month on "sheet 2 H5".
Needed:
How do I get the cells to be blank or have N/A for the dates outside the month range from sheet 2 cell H5?