Find the Date of the Next Friday
On Wed, 6 May 2009 21:50:41 -0600, Thomas M.
wrote:
I found a formula on the Internet that works.
=TODAY()-WEEKDAY(TODAY())+IF(WEEKDAY(TODAY())6,13,6)
Anyone have a better way of doing this?
--Tom
As Rick wrote, merely substitute TODAY() for A1 in the formula I previously
posted.
=A1+7-WEEKDAY(A1+1)
or put TODAY() in A1 or some other cell to be referenced.
The formula I posted can be generalized to:
=A1+7-WEEKDAY(A1+7-DOW)
where DOW is Day Of Week and 1=Sun,2=Mon...6=Fri,7=Sun
--ron
|