Please help me out with this last question and ill have this workbook complete!
Sheet 3 in the workbook is a self made chart
Column A is project name
Column B is start Date
Column C is End date
I have than made a table for the full year
(columns D THROUGH AH) are JANUARY 31 DAYS
(Columns AH THROUGH BK are Febuary 29 Days
and so on with December 31 ending in column NE
all of these dates are in those columns and across row 2
what I am trying to figure out is how or what macro do i use in the first cell below january (cell d3) so that with the start date in column b and end date in column C those are entered and i select across the entire row it will fill the proper dates with 1's and 0's where applicable, Than i will turn the font to white so it doesnt show up and have it converted to a bar resulting in a self made bar chart represented off the start and end dates
so basically once i enter the start and end dates i want to than just click and drag across the entire row and have it automatically fill out the 1's and 0's or if somehow will automatically change to the bar once i click and drag that would be awesome but if not i cant figure it out either way
i tried entering =IF(AND($B3<=D$2,$C3>=D$2),1,0)
but when i drag it across the row it only copies all the 0's its not applying 1's where the project is undergo
please help me
Bookmarks