Perpetual 1st Wed

[Keyrookie]

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

 

[Ron Rosenfeld]

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

 

[Mike H]

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]

Thanks to you both. I love this forum!

Keyrookie