Excel 2007
I have this code
=IF(DAY(A1)<=15,DATE(YEAR(A1),MONTH(A1),15),EOMONTH(A1,0))
The issue I have is the every other row in a range CH6:CH1000 show the date for the month and day and the other row has #VALUE!
After thought,
what I really want to do is in column CH6:CH1000 every row where the is data in range column C6:L1000 I would like to display the 15th of every month for the current year and any row in range C6:L1000 is blank then in CH6:CH1000 is blanks until data is populated.
I have this code
=IF(DAY(A1)<=15,DATE(YEAR(A1),MONTH(A1),15),EOMONTH(A1,0))
The issue I have is the every other row in a range CH6:CH1000 show the date for the month and day and the other row has #VALUE!
After thought,
what I really want to do is in column CH6:CH1000 every row where the is data in range column C6:L1000 I would like to display the 15th of every month for the current year and any row in range C6:L1000 is blank then in CH6:CH1000 is blanks until data is populated.