| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
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
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
|
|||
|
|||
|
Thanks to you both. I love this forum!
Keyrookie Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Appointments, Perpetual Calender | Excel Discussion (Misc queries) | |||
| Perpetual Calendar | Excel Worksheet Functions | |||
| How do I calculate NPV of perpetual annuity. | Excel Worksheet Functions | |||
| Perpetual calander | Excel Worksheet Functions | |||
| perpetual dates | Excel Discussion (Misc queries) | |||
Linear Mode
