getting future dates from an existing date
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
|