Automatic filling of cells within a certain date range


E

Elor

Can someone please help, I have been stuck on this for the past two days...

Column 'AB' has 'Start Date' and column 'AD' has 'Finish date'

Row 19, cells 'AI' to 'DW' have the months written as 'J' 'F' 'M' 'A'
etc.....from 2008 to 2015.

I want to be able to enter a 'start date' in column 'AB' i.e. 1 January 2008
and a 'Finish date' in column 'AD' i.e. 1 April 2015. Then i would like the
cells 'J - A' on row 19 to be filled with '1' in each month....

I managed to get it to calculate for only 12 months...

here is what i have so far -

=IF(AND(COLUMNS($AI32:BB32)>=MONTH($AB32),COLUMNS($AI32:BB32)<=MONTH($AD32)),1,"")

Thanks in advance,

Elor
 
Ad

Advertisements

D

Don Guillett

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top