Greetings,
Im working with a template that has the following expression:
=IF(AND($B10="Goal",H$5>=$E10,H$5<=$E10+$F10-1),2,IF(AND($B10="Milestone",H$5>=$E10,H$5<=$E10+$F10-1),1,""))
The value in Column F is currently # of days - I'd like to change that to an End Date and would really like some help - not sure where to begin! IN the example above, # of days is 3 - My ideal state is to have this as a date format such as 2018-11-26
The result of the formula is a gantt chart.
Thanks in advance for your suggestions!
Im working with a template that has the following expression:
=IF(AND($B10="Goal",H$5>=$E10,H$5<=$E10+$F10-1),2,IF(AND($B10="Milestone",H$5>=$E10,H$5<=$E10+$F10-1),1,""))
The value in Column F is currently # of days - I'd like to change that to an End Date and would really like some help - not sure where to begin! IN the example above, # of days is 3 - My ideal state is to have this as a date format such as 2018-11-26
The result of the formula is a gantt chart.
Thanks in advance for your suggestions!
