List First Friday's Date of the year
 

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

List First Friday's Date of the year
 

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"seanrigby" wrote
in message ...

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

List First Friday's Date of the year
 

Excellent! Thanks!


--
seanrigby
------------------------------------------------------------------------
seanrigby's Profile: http://www.excelforum.com/member.php...o&userid=34133
View this thread: http://www.excelforum.com/showthread...hreadid=539946