Natalie
its very difficult to know what to say to you without a few more details. Like Lyn says there are other reasons for confusion, UTIs can cause terrible confusion. It does appear from what you say though that your dad is in palliative care but its not clear whether he has hospice support. No one here can tell you how long he has as we are not medics, but the palliative care team will give you their best view of how things are going, assuming mum and dad want to share that information (sounds like they will). Often they will put it in terms of months or weeks rather than being specific if that were to be the case or if its not that way they wont say as no one can.
Last week my husband was potentially too ill for further treatment, this week he has picked up and is going to be having some additional treatment. We don’t kid ourselves though, this is giving us time potentially, and that is gratefully received but no promises. If you read the posts by Kentish you will see how someone who is terminally ill still rallies from day to day, these are written by his wife. Depending on your state of mind, it might be helpful to read. If you are very fearful then maybe don’t. It does give good insight into it from a family perspective which could be useful.
Apart from that, you have my deepest sympathy for what you are all going through, it is very frightening. i do hope that you have Hospice support as they will be able to help the whole family through this.
with love Devonmaid xxx