jamesaplant77
New Member
- Joined
- Apr 22, 2015
- Messages
- 16
Hi guys,
I am producing a milestone view based on a variety of columns containing dates and this then plots out milestones based on the results.
=IF(AND($P7>=AF$5,$P7<=AH$5-1),"u",IF(AND(AF$5>=$Q7,AH$5<=$R7),"2",IF(AND($T7>=AF$5,$T7<=AH$5-1),"l",IF(AND(AF$5>=$T7,AH$5<=$U7),"3",IF(AND(AF$5>=$V7,AH$5<=$W7),"4","")))))
AF$5 would be 01/04/2017 and AH$5 would be 02/04/2017 and so on, it's just checking if the cell reference falls between the two dates then place either, u,l,2,3 or 4.
It works for all the milestones apart from plotting milestone l.
Milestone 2 would be for example 01/04/2017 - 27/06/2017
Milestone l would be 28/06/2017
Milestone 3 would from 29/06/2017 - 31/12/2017
It is just so that I can plot a circle for this milestone using wingdings!!!
Can someone please help, it must be simple, but I just can't get my head around it!!
I am producing a milestone view based on a variety of columns containing dates and this then plots out milestones based on the results.
=IF(AND($P7>=AF$5,$P7<=AH$5-1),"u",IF(AND(AF$5>=$Q7,AH$5<=$R7),"2",IF(AND($T7>=AF$5,$T7<=AH$5-1),"l",IF(AND(AF$5>=$T7,AH$5<=$U7),"3",IF(AND(AF$5>=$V7,AH$5<=$W7),"4","")))))
AF$5 would be 01/04/2017 and AH$5 would be 02/04/2017 and so on, it's just checking if the cell reference falls between the two dates then place either, u,l,2,3 or 4.
It works for all the milestones apart from plotting milestone l.
Milestone 2 would be for example 01/04/2017 - 27/06/2017
Milestone l would be 28/06/2017
Milestone 3 would from 29/06/2017 - 31/12/2017
It is just so that I can plot a circle for this milestone using wingdings!!!
Can someone please help, it must be simple, but I just can't get my head around it!!