That will return the same as the formula I gave Totti

you can leave out the 1

--


Regards,


Peo Sjoblom

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Try

=A1+7-WEEKDAY(A1+2,1)

HTH,
Bernie
MS Excel MVP


"Totti" wrote in message
...
Dear, Peo Sjoblom

Thank you a lot first of all for :

First Friday of next month is

=DATE(YEAR(A1),MONTH(A1)+1,0)+8-
WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0)+2)

First Monday next even months

=DATE(YEAR(A1),CEILING(MONTH(A1)+1,2),0)+4-
WEEKDAY(DATE(YEAR(A1),CEILING(MO*NTH(A1)+1,2),0)+2 )

they are working amazingly, but
Next Thursday

=A1+7-WEEKDAY(A1+2)

is not, i even put on the next row,
=TEXT(DATE(YEAR(E2),MONTH(E2),DAY(E2)),"Dddd")
to check if the day is thursday and i see they are not! and i doubled
check my formula fo rgetting the day with the 2 solutions you gave me
which i said they are working and i saw they are all fridays or all
mondays and this is what i want. but as long as next thursday is
concerned. unfortunately not! it is not