Dates for European Summer Time

[Victor Delta]

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]

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

 

[Victor Delta]

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

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

 

[Bob I]

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.

 

[Ron Rosenfeld]

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

 

[Victor Delta]

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

 

[Ron Rosenfeld]

Ron

Many thanks,

V

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