LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Automatic filling of cells within a certain date range

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Cell Filling Craig Excel Discussion (Misc queries) 3 November 4th 08 01:36 PM
Automatic Data Update by Date Range [email protected] Excel Worksheet Functions 1 October 1st 08 07:30 PM
Filling in a cell based on another cells date criteria cmatera Excel Worksheet Functions 5 August 21st 08 02:27 PM
Break up a date range automatic Cory Excel Worksheet Functions 4 June 30th 08 05:04 AM
automatic filling in cells in excel CA user Excel Worksheet Functions 2 July 17th 05 03:06 AM


All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"