|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 7th, 2010, 01:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Perpetual 1st Wed
Hey all, What is the formula that always shows the 1st Wednesday of the month? I am wanting to have the date of the the first Wed. of the month always appear in cell B7. When the month changes I want the date in cell B7 to change. Thanks -- Keyrookie 
|
|
#2
February 7th, 2010, 02:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Perpetual 1st Wed
On Sun, 7 Feb 2010 13:23:31 +0000, Keyrookie
wrote: Hey all, What is the formula that always shows the 1st Wednesday of the month? I am wanting to have the date of the the first Wed. of the month always appear in cell B7. When the month changes I want the date in cell B7 to change. Thanks B7: =TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())-3) --ron
|
|
#3
February 7th, 2010, 02:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Perpetual 1st Wed
Hi,
Try this =TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())-3) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Keyrookie" wrote: Hey all, What is the formula that always shows the 1st Wednesday of the month? I am wanting to have the date of the the first Wed. of the month always appear in cell B7. When the month changes I want the date in cell B7 to change. Thanks -- Keyrookie .
|
|
#4
February 7th, 2010, 09:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Perpetual 1st Wed
Thanks to you both. I love this forum! Keyrookie Mike H;925773 Wrote: Hi, Try this =TODAY()-DAY(TODAY())+8-WEEKDAY(TODAY()-DAY(TODAY())-3) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Keyrookie" wrote: - Hey all, What is the formula that always shows the 1st Wednesday of the month? I am wanting to have the date of the the first Wed. of the month always appear in cell B7. When the month changes I want the date in cell B7 to change. Thanks -- Keyrookie . - -- Keyrookie
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
