Cantonalives
Member
Hi All,
Irritated myself with what should be simple. Basically I am creating a Gantt chart based on start and end date. So if the Start date is greater the week commencing and the end date is less than or equal to the next week, a "Y" is the value.
Please see attached to see my jumble. Was using an AND formula, but the logic was not quite right.
Any thoughts, much appreciated.
Thanks.
-CL
Irritated myself with what should be simple. Basically I am creating a Gantt chart based on start and end date. So if the Start date is greater the week commencing and the end date is less than or equal to the next week, a "Y" is the value.
Please see attached to see my jumble. Was using an AND formula, but the logic was not quite right.
Any thoughts, much appreciated.
Thanks.
-CL