AUTO POPULATE 15th EACH MONTH

jaxs2009

Board Regular
Joined
Nov 28, 2010
Messages
200
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.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,109,466
Messages
5,528,968
Members
409,848
Latest member
Blomsten
Top