Formula to Return the next 1st Tuesday of a Month

D

daddylonglegs

This formula will give next first Tuesday at noon, based on a cutoff of noon
on the 1st Tuesday

=FLOOR(EOMONTH(FLOOR(A1+3.5,7)-4,0)+4,7)+3.5

similarly this will give last Thursday at noon also based on a cutoff at
noon on last Thursday

=FLOOR(EOMONTH(FLOOR(A1+1.5,7)+5,0)+2,7)-1.5

Note: only works correctly with 1900 date system
 
H

Harlan Grove

daddylonglegs said:
This formula will give next first Tuesday at noon, based on a cutoff
of noon on the 1st Tuesday

=FLOOR(EOMONTH(FLOOR(A1+3.5,7)-4,0)+4,7)+3.5

similarly this will give last Thursday at noon also based on a
cutoff at noon on last Thursday

=FLOOR(EOMONTH(FLOOR(A1+1.5,7)+5,0)+2,7)-1.5

Note: only works correctly with 1900 date system
Click to expand...
....

Note also that in Excel 2003 and prior it requires loading the
Analysis ToolPak add-in, since EOMONTH isn't a built-in function in
those older versions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Using a Date and corresponding weekday to pull amounts 1
Return mm/dd/yy based on 1st Day of Month 5
How to set formula for poping up the date of next Wednesday.... 2
IF ARRAY with multiple conditions. 1
Allocate an income payment over a date range (tax years) 7
Modifying a complex date formual to count months 4

Top