date formula with a condition or rule

[cgreen]

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?

 

[cyrilbrd]

Hi,
in A2 type =IFERROR(IF(A1+1>EOMONTH($A$1,0),"",A1+1),"") copied down till needed

 

[skywriter]

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?

Your post is confusing. If you have the formula in A1 as you show and you copy it down as you say, the formula copied down one cell would be A2=DATE(Sheet2!H7,Sheet2!H6,1) and you said H6 contains 2016, which means that number would be in the formula where the argument for the month would go? What am I missing here?