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
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