Prev: Change cell background color based on content that results from li
Next: Auto calculating time
From: Victor Delta on 24 Mar 2010 19:37
"Ron Rosenfeld" <ronrosenfeld(a)nospam.org> wrote in message
news:vnmiq5p2km3h10hoijk93foopddq9aklhu(a)4ax.com...
> 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

Many thanks,

V

From: Ron Rosenfeld on 25 Mar 2010 06:17
On Wed, 24 Mar 2010 23:37:06 -0000, "Victor Delta" <none(a)nospam.com> wrote:

>Ron
>
>Many thanks,
>
>V

Glad to help. Thanks for the feedback.
--ron
First  |  Prev  | 
Pages: 1 2
Prev: Change cell background color based on content that results from li
Next: Auto calculating time