Prev: Change cell background color based on content that results from li
Next: Auto calculating time
From: Victor Delta on 23 Mar 2010 14:45
European Summer Time starts this Sunday (the last Sunday in March).

Does anyone know of any formulae to compute the start and finish dates
automatically for the current year please?

TIA

V

From: Bob I on 23 Mar 2010 15:12

http://www.greenwichmeantime.com/time-zone/rules/eu.htm

Victor Delta wrote:

> European Summer Time starts this Sunday (the last Sunday in March).
>
> Does anyone know of any formulae to compute the start and finish dates
> automatically for the current year please?
>
> TIA
>
> V

From: Victor Delta on 23 Mar 2010 17:00
"Bob I" <birelan(a)yahoo.com> wrote in message
news:uxLvSzryKHA.4752(a)TK2MSFTNGP04.phx.gbl...
>
> http://www.greenwichmeantime.com/time-zone/rules/eu.htm
>
> Victor Delta wrote:
>
>> European Summer Time starts this Sunday (the last Sunday in March).
>>
>> Does anyone know of any formulae to compute the start and finish dates
>> automatically for the current year please?
>>
>> TIA
>>
>> V

Bob

Many thanks for that - a very interesting website. However, I was hoping
someone would have a couple of formulae for calculating the dates of the
last Sundays in March and October.

V

From: Bob I on 23 Mar 2010 17:35


Victor Delta wrote:

> "Bob I" <birelan(a)yahoo.com> wrote in message
> news:uxLvSzryKHA.4752(a)TK2MSFTNGP04.phx.gbl...
>
>>
>> http://www.greenwichmeantime.com/time-zone/rules/eu.htm
>>
>> Victor Delta wrote:
>>
>>> European Summer Time starts this Sunday (the last Sunday in March).
>>>
>>> Does anyone know of any formulae to compute the start and finish
>>> dates automatically for the current year please?
>>>
>>> TIA
>>>
>>> V
>
>
> Bob
>
> Many thanks for that - a very interesting website. However, I was hoping
> someone would have a couple of formulae for calculating the dates of the
> last Sundays in March and October.
>
> V

I think I'd work with EOM and WEEKDAY to back into it.

From: Ron Rosenfeld on 23 Mar 2010 20:22
On Tue, 23 Mar 2010 21:00:28 -0000, "Victor Delta" <none(a)nospam.com> wrote:

>Many thanks for that - a very interesting website. However, I was hoping
>someone would have a couple of formulae for calculating the dates of the
>last Sundays in March and October.

With the Year in A1:

Last Sunday in March:
=DATE($A$1,4,1)-WEEKDAY(DATE($A$1,4,1)-1)

Last Sunday in October
=DATE($A$1,11,1)-WEEKDAY(DATE($A$1,11,1)-1)

--ron
 |  Next  |  Last
Pages: 1 2
Prev: Change cell background color based on content that results from li
Next: Auto calculating time