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

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 I" wrote in message
...

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

Victor Delta wrote:

"Bob I" wrote in message
...


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.

On Tue, 23 Mar 2010 21:00:28 -0000, "Victor Delta" 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

"Ron Rosenfeld" wrote in message
...
On Tue, 23 Mar 2010 21:00:28 -0000, "Victor Delta"
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

Many thanks,

V

On Wed, 24 Mar 2010 23:37:06 -0000, "Victor Delta" wrote:

Ron

Many thanks,

V

Glad to help. Thanks for the feedback.
--ron