software

Hello,

I am creating a time card. I would like a formula that will calculate
(show) Fridays date closest to the date when the spreadsheet is opened. For
example If I opened the sheet today the formula would populate yesterdays
date. If I opened the sheet on Tuesday, the sheet formula will populate next
Fridays date, etc…

ThanksAssuming the date of the sheet opening is in A1.....

=TEXT(A1 LOOKUP(WEEKDAY(A1),{1,2,3,4,5,6,7},{-2,-3,3,2,1,0,-1}),quot;mm/dd/yyyy
ddddquot;)

Vaya con Dios,
Chuck, CABGx3
quot;Jimquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I am creating a time card. I would like a formula that will calculate
gt; (show) Fridays date closest to the date when the spreadsheet is opened.
For
gt; example If I opened the sheet today the formula would populate yesterdays
gt; date. If I opened the sheet on Tuesday, the sheet formula will populate
next
gt; Fridays date, etc.
gt;
gt; Thanks
gt;

Try this formula

=TODAY() CHOOSE(WEEKDAY(TODAY()),-2,-3,3,2,1,0,-1)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=501413perfect

quot;CLRquot; wrote:

gt; Assuming the date of the sheet opening is in A1.....
gt;
gt; =TEXT(A1 LOOKUP(WEEKDAY(A1),{1,2,3,4,5,6,7},{-2,-3,3,2,1,0,-1}),quot;mm/dd/yyyy
gt; ddddquot;)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Jimquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt;
gt; gt; I am creating a time card. I would like a formula that will calculate
gt; gt; (show) Fridays date closest to the date when the spreadsheet is opened.
gt; For
gt; gt; example If I opened the sheet today the formula would populate yesterdays
gt; gt; date. If I opened the sheet on Tuesday, the sheet formula will populate
gt; next
gt; gt; Fridays date, etc.
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;