Excel Date Calculation

[Andy Roberts]

Hiya,

I'm trying to do a calculation in Excel that based on a date in a cell will mark it as either "Awaiting Scheduled", "Completed" or "On Hold". The formula I was working with is:-

=IF(ISBLANK(A2),"Awaiting Schedule",IF(A2="43831","On Hold", "Scheduled"))

If the cell A2 is blank then it flags as Awaiting Schedule. If the cell has a date in it in dd/mm/yyyy and the date equals 01/01/2020 then flag it as "On Hold" but for any other date mark it as "Scheduled".

The problem is that when I try and do the A2="43831","On Hold" bit it doesn't like it. I originally had it as A2="01/01/2020" but this didn't work either and I was told by a collegue that it is because excel references dates as serial numbers. So I found the serial number for the date in Excel, put this in the formula but it still does not work correctly. The cell is formatted in the correct way but I just can't get it to work.

Any ideas what I'm doing wrong?

Regards,

Andy

[Renée]

</font><blockquote><font size="1" face="Trebuchet MS, Verdana, Arial, Helvetica, sans-serif">quote:</font><hr /><font size="2" face="Trebuchet MS, Verdana, Arial, Helvetica, sans-serif">=IF(ISBLANK(A2),"Awaiting Schedule",IF(A2="43831","On Hold", "Scheduled"))</font><hr /></blockquote><font size="2" face="Trebuchet MS, Verdana, Arial, Helvetica, sans-serif">Take away the quotes around 43831, and it should work fine. Excel reads anything in quotes as text.

[Andy Roberts]

Knew it would be nice and simple

Thanks for your help again Renée.

AndyR

[Renée]

No problem...any old time!