IF(AND formula with Dates

[amcmlt]

Hello, I'm a little frustrated with myself for not being able to find a solution for this issue. In my worksheet, I have a start date (F29) and a completion date (H29) calculated from a task duration time that references a calendar of dates above (T9). The formula I have is: =IF($C29="","",IF(AND(T$9>=$F29,T$9<=$H29),"X","")). Very basic but when I have a start date and completion date that are the same date, the formula enters the "" in to the cell.

I have checked the format for all cells and the setting is correct. What am I missing?

Thanks!!!

 

[James006]

For a totally anonymized worksheet ... just delete everything but the cells required to solve your problem ... :wink:

 

[amcmlt]

Hello, here's another way to describe the situation:

Column C = Equipment (Workstation ID)
Column D = Duration of Task
Column E = Clock Start (Setup/Run of workstation)
Column F = Start Date (Date the workstation is to start)
Column G = Clock End (Workstation finishes task)
Column H = End Date (Date the workstation is to complete process)

Start Date is calculated using: Completion Date - Duration time
End Date is calculated using: Start date from previous task

The data is used to create a Gantt chart that is based on the End Completion Date and calculates hours/minutes back to first start date and time.

Column F and G are formatted as "Sunday, October 7, 2018".

When Columns F and G have different dates is the same row, all is good. When dates are the same in the row, the worksheets does not enter the "X" in to the cell from formula listed at the beginning of this post. I have checked by simply entering this formula: F31 = G31. This should return a TRUE but returns a FALSE.

Hopefully, this will help explain the situation clearly and someone can point me in the direction to correct the formula.

Thanks again!