Dates for European Summer Time
 

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

Dates for European Summer Time
 

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

Dates for European Summer Time
 

"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

Dates for European Summer Time
 

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.

Dates for European Summer Time
 

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

Dates for European Summer Time
 

"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

Dates for European Summer Time
 

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

Ron

Many thanks,

V

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