Posted to microsoft.public.excel.worksheet.functions

Jessica[_2_] Jessica[_2_] is offline

external usenet poster

Posts: 1

dates and 1st Tuesday of month

How can I get the cells to populate with the dates of the 1st Tuesday of the
month?

I tried =C26+7+7*(MONTH(C26+7)=MONTH(C26)) but that gives me every Tuesday.

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Every 1st, 3rd, 5th Tuesday	Rick[_3_]	Excel Worksheet Functions	9	June 12th 07 02:05 PM
Calculating first/last Monday, Tuesday, etc. in a given month in E	Rossta	Excel Worksheet Functions	3	May 27th 06 02:19 AM
Dates - Several Days In a month to month only	Andy_Pimp	Excel Discussion (Misc queries)	1	February 28th 06 11:11 AM
dates in one month	Vibeke	Excel Worksheet Functions	5	January 27th 06 12:26 AM
dates, 1st of month	LatinViolin	Excel Worksheet Functions	3	February 21st 05 04:38 PM

All times are GMT +1. The time now is 08:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us