Totti,


With the date in A1:

The first Friday of the next month:
=DATE(YEAR(A1),MONTH(A1)+1,1)+7-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,1)+1)

The first Monday of the next even month:
=DATE(YEAR(A1),MONTH(A1)+IF(MOD(MONTH(A1),2)=0,2,1 ),1+((1-(2=WEEKDAY(DATE(YEAR(A1),MONTH(A1)+IF(MOD(MONTH(A 1),2)=0,2,1),1))))*7)+(2-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+IF(MOD(MONTH(A1),2 )=0,2,1),1))))

HTH,
Bernie
MS Excel MVP


"Totti" wrote in message
...
Hi everyone,
I have an excel sheet filled with dates of this year and few future
years, i am intending to use it as a worksheet for knowing some prcise
dates and put precise job for these days, this part is obvious i ll
use the conditional formatting and LOOKUP functions for the jobs. the
hard part for me is in finding 3 dates in 3 columns

col 1 -- Next Thursday (if date is a Thursday then the date itself)
col 2 -- The first Friday of the next month
col 3 -- The first Monday of the next even month (Feb, Apr, Jun, Aug,
Oct, Dec)

Actually i will be using these specific days for specific jobs(col 1)
or payments (col 2 & 3)
my dates are in col 0 and they are formatted as "dd.mm.yy"

I know i am asking for too much, and i appreciate any help in these
tasks.