Format for 1st and 3rd Tuesday of each month?

  • Thread starter Thread starter Roger Fuherdenhaden
  • Start date Start date
R

Roger Fuherdenhaden

Ok experts,

I have a cell that takes todays date from A1, subtracts A2 to end up on a new date, but I need the new date to be the first or third
Tuesday of a month.

And, it needs to round it to the Tuesday that is not past the true sum date, i.e., higher.

Example

TODAYS DATE = 5/26/04
A2 = 10
That would equal 5/16/04, a Sunday.

Though it is closer to Tuesday the 18th, I need it to round to Tuesday the 4th.

Thanks.
 
try the first one
=DATE(YEAR(A1),MONTH(A1),1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),1)-3)+7
or
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY
()),1)-3)+7
--
Don Guillett
SalesAid Software
(e-mail address removed)
Roger Fuherdenhaden said:
Ok experts,

I have a cell that takes todays date from A1, subtracts A2 to end up on a
Click to expand...
new date, but I need the new date to be the first or third
 
Back
Top