Re: [OT] Excel Golf: Unix Time to Excel Time in one line

[email protected] (Jasper) Tue, 26 Oct 2004 14:25:50 +0100

Newsgroups	perl.golf
Message-ID	<[email protected]>

On Tue, 26 Oct 2004 13:58:04 +0100, McGlinchy, Alistair
<[email protected]> wrote:

> =       DATE(1970,1,1)+ A2/24/60/60+1/24 *
>        AND(
>                DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),5,1)
>                        -
>                WEEKDAY(DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),5,1),2)
>                        +
>                1/24
>        <
>                DATE(1970,1,1)+A2/24/60/60
>        ,
>                DATE(1970,1,1)+A2/24/60/60
>        <
>                DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),11,1)
>                        -
>                WEEKDAY(DATE(YEAR(DATE(1970,1,1)+A2/24/60/60),11,1),2)
>                        +
>                1/24
>        )

Would another cell with DATE(1970,1,1)+A2/24/60/60 in it not help matters a bit?

I know nothing about excel

-- 
Jasper