List First Friday's Date of the year

[seanrigby]

Would like to type in a year, and from that year, I would like to list the first Friday of that year.

For example:

A1: 2006 (this I would type in, but could change to a different year)
B1: lists the first friday of this year automatically. If the year changes, so will this date.

Any help would be appreciated.

Thanks!

[Peo Sjoblom]

=DATE(A1,1,1+7)-WEEKDAY(DATE(A1,1,8-6))

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"seanrigby" <[email protected]> wrote
in message news:[email protected]...
>
> Would like to type in a year, and from that year, I would like to list
> the first Friday of that year.
>
> For example:
>
> A1: 2006 (this I would type in, but could change to a different year)
> B1: lists the first friday of this year automatically. If the year
> changes, so will this date.
>
> Any help would be appreciated.
>
> Thanks!
>
>
> --
> seanrigby
> ------------------------------------------------------------------------
> seanrigby's Profile:
> http://www.excelforum.com/member.php...o&userid=34133
> View this thread: http://www.excelforum.com/showthread...hreadid=539946
>

[seanrigby]

Excellent! Thanks!