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.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,223,246
Messages
6,170,988
Members
452,373
Latest member
TimReeks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top