Complex IF Statement help please!

abmatch

New Member
Joined
Nov 23, 2018
Messages
1
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!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,399
Office Version
365
Platform
Windows
Assuming E10 is a date, how about
=IF(AND($B10="Goal",H$5>=$E10,H$5<=$F10),2,IF(AND($B10="Milestone",H$5>=$E10,H$5<=$F10),1,""))
 

Forum statistics

Threads
1,082,504
Messages
5,365,962
Members
400,864
Latest member
RobynP51

Some videos you may like

This Week's Hot Topics

Top