Dates for European Summer Time

  • Thread starter Thread starter Victor Delta
  • Start date Start date
V

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
 
Victor said:
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
Click to expand...

I think I'd work with EOM and WEEKDAY to back into it.
 
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.
Click to expand...

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 said:
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)
Click to expand...

Ron

Many thanks,

V
 
Back
Top