Identify if date and time is in the past

[sharky12345]

This may be a big ask, but worth asking the experts.....

I have a worksheet with dates in 1 column and times in another - I need to identify if the date and time is in the past and display text for the result.

The dates are in column C and are formatted as "dd/mm/yyyy". The times are in column D and formatted as "hh:mm".

I need the text in column I to be as follows;

1) If date and time is in the future then text to read "FUTURE"
2) If date and time is in the past but not be more than 12 hours then text to read "EXPIRING"
3) If date and time is in the past and more than 12 hours then text to read "EXPIRED"

Is this anywhere near possible guys?

 

[Mentor82]

This may be a big ask, but worth asking the experts.....

I have a worksheet with dates in 1 column and times in another - I need to identify if the date and time is in the past and display text for the result.

The dates are in column C and are formatted as "dd/mm/yyyy". The times are in column D and formatted as "hh:mm".

I need the text in column I to be as follows;

1) If date and time is in the future then text to read "FUTURE"
2) If date and time is in the past but not be more than 12 hours then text to read "EXPIRING"
3) If date and time is in the past and more than 12 hours then text to read "EXPIRED"

Is this anywhere near possible guys?

Hi,
Check this formula placing in column I. I assume your data start from row 2. If not, adjust it in the formila below.

=IF(C2+D2>Now();"Future";IF(Now()-(C2+D2)<=1/24*12;"Expiring";"Expired"))

 

[sharky12345]

Perfect - works a treat, (I had to replace ; with , but just a minor tweak).

Thanks!

 

[Mentor82]

Thanks for the feedback. So sorry.for the mistake with ";" instead of ",". I wrote the formula on my mobile and still forget that in English excel it's used "," - I'm from Poland and in Polish excel it's used ";" instead.
However, it's good to know that I've helped you somhow to solve your issue
My pleasure
Regards,
Sebastian