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!!!

 

[Dave Patton]

What is in C29?

The formula should yield X if And it True.

 

[cowboysnut]

No idea. It worked for me copying and pasting your formula. I feed T9, F29, and H29 today's date and put some text in C29 and it gave me "X." One thing you didn't say was if you had T9 in the date of F29 and H29 (or in this case the same date as those 2 cells), but that's important for your formula to work.

 

[amcmlt]

Task description.

 

[James006]

Hello,

If you are working with Actual Dates ...

You should test the Int() function : Int($F29) and Int($H29) ...

HTH

 

[amcmlt]

I agree with you but the formula is not yielding an X in the cell. I have rekeyed the formula but result is the same.

 

[James006]

Would you have he possibility to copy your file ...say ... on Google Drive ...?

 

[Joyner]

Are you sure they are actual dates in the cells. I know you said you check the format of the cells, but the format will have nothing to do with what is actually in the cells. So if the cell is formatted as General, you should see something like 47895 not 5/24/2018.

 

[amcmlt]

The output for the date is correct and is showing 5/24/2018.

 

[amcmlt]

Sorry I cannot share the worksheet. Confidential workplace data.