Posted to microsoft.public.excel.worksheet.functions

Sean

external usenet poster

Posts: 454

Formula to Return the next 1st Tuesday of a Month

How can I construct a formula that will relate TODAY to the 1st
Tuesday of each month.

For example as today is 01/12/07, my formula should return 04/12/07,
but if TODAY was 05/12/07, then it should return 01/01/08 etc

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
function to return day in the form "Monday", "Tuesday" etc given .	MTro	Excel Worksheet Functions	2	October 3rd 07 09:49 AM
dates and 1st Tuesday of month	Jessica[_2_]	Excel Worksheet Functions	11	July 17th 07 11:13 PM
Return mm/dd/yy based on 1st Day of Month	Ken	Excel Worksheet Functions	5	February 9th 07 07:15 PM
Calculating first/last Monday, Tuesday, etc. in a given month in E	Rossta	Excel Worksheet Functions	3	May 27th 06 02:19 AM
Return 1st of the Month	JJalomo	Excel Worksheet Functions	12	May 18th 05 03:52 PM

All times are GMT +1. The time now is 01:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us