Jack in the UK
Well-known Member
- Joined
- Feb 16, 2002
- Messages
- 3,215
Hi guys
="Licenced to:- " & MIN('22159'!D4:D5)
This wil return serial date need dddd mmmm yyyy, but =MIN('22159'!D4:D5) works just fine, ??? need a fix guys any ideas!
2
OK as above but if min is greater than 2 years old 742 days reads EXPIRED and the date or which is MIN, but the twist.
If both dates are older that 2 years need result as
Expired - oldest dats & other date
Will only be these two cells all is fixed i have MADE SURE
Cheers guys
="Licenced to:- " & MIN('22159'!D4:D5)
This wil return serial date need dddd mmmm yyyy, but =MIN('22159'!D4:D5) works just fine, ??? need a fix guys any ideas!
2
OK as above but if min is greater than 2 years old 742 days reads EXPIRED and the date or which is MIN, but the twist.
If both dates are older that 2 years need result as
Expired - oldest dats & other date
Will only be these two cells all is fixed i have MADE SURE
Cheers guys