Iain McBride
New Member
- Joined
- Aug 17, 2018
- Messages
- 38
I have set up a gantt chart using excel formulas- with the start and end dates of activities, however I have been told that the activity only happens once every 2 weeks - can anyone help with the formula to edit what I have done so far....
=IF(AND(G$9>=$D18,G$9<=$E18),"X","")
This is where I am currently with it all - and getting nowhere to add in an every 2 weeks formula.
Thanks in advance.
Iain
=IF(AND(G$9>=$D18,G$9<=$E18),"X","")
This is where I am currently with it all - and getting nowhere to add in an every 2 weeks formula.
Thanks in advance.
Iain