Sanjiyapunia
New Member
- Joined
- Jan 5, 2017
- Messages
- 1
Hi all,
I have an excel file.
1 of the sheet contains a list of project milestones (multiple projects, multiple milestones, some may have the same end date) with respective end dates associated to it. the other sheet has a calendar format speadsheet (January, Mondays to Friday from 1 to 31) which pulls the milestone names under the respective date.
The change i would like to make is that the sheet with the project milestone should now have a start date and an end date instead of just the end date.
what I'm having trouble with is getting that milestone to show up on the different dates between the start and the end date. For example if milestone 1 now has a start date of 1-jan-2017 and end date of 4-jan-2017, i want the calendar to show the name of the milestone under all of the days, 1-jan-2017, 2-jan-2017, 3-jan-2017, 4-jan-2017.
The formulas I use on the calendar sheet is this:
=IF(ISERROR(INDEX('NPI Timelines'!$B:$C,SMALL(IF('NPI Timelines'!$B:$C=$E$3,ROW('NPI Timelines'!$B:$C)),ROW(1:1)),2)),"",INDEX('NPI Timelines'!$B:$C,SMALL(IF('NPI Timelines'!$B:$C=$E$3,ROW('NPI Timelines'!$B:$C)),ROW(1:1)),2))
Your help is greatly appreciated.
Thank you in advance.
I have an excel file.
1 of the sheet contains a list of project milestones (multiple projects, multiple milestones, some may have the same end date) with respective end dates associated to it. the other sheet has a calendar format speadsheet (January, Mondays to Friday from 1 to 31) which pulls the milestone names under the respective date.
The change i would like to make is that the sheet with the project milestone should now have a start date and an end date instead of just the end date.
what I'm having trouble with is getting that milestone to show up on the different dates between the start and the end date. For example if milestone 1 now has a start date of 1-jan-2017 and end date of 4-jan-2017, i want the calendar to show the name of the milestone under all of the days, 1-jan-2017, 2-jan-2017, 3-jan-2017, 4-jan-2017.
The formulas I use on the calendar sheet is this:
=IF(ISERROR(INDEX('NPI Timelines'!$B:$C,SMALL(IF('NPI Timelines'!$B:$C=$E$3,ROW('NPI Timelines'!$B:$C)),ROW(1:1)),2)),"",INDEX('NPI Timelines'!$B:$C,SMALL(IF('NPI Timelines'!$B:$C=$E$3,ROW('NPI Timelines'!$B:$C)),ROW(1:1)),2))
Your help is greatly appreciated.
Thank you in advance.