For first Mon of next month
enter in B1
=DATE(IF(MONTH(A1)=12,YEAR(A1)+1,YEAR(A1)),MONTH(A 1)+1,1) to get first day
of next month
and in C1
=IF(WEEKDAY(B1,1)2,B1+9-WEEKDAY(B1,1),B1+2-WEEKDAY(B1,1)) to get the next Mon

Use this to get first day of next even month
=DATE(YEAR(A1),IF(MOD(MONTH(A1),2),MONTH(A1)+1,MON TH(A1)+2),1)
Try to combine these two to get the remaining results...


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Sheeloo" wrote:

If your date is in A1 then
=IF(WEEKDAY(A1,1)5,A1+12-WEEKDAY(A1,1),A1+5-WEEKDAY(A1,1))
will give you the date of next Thur (or today if it is Thu). Format the cell
with the formula as a date..

I will give the other formulae after some time.
In the meantime, you can try on your own.
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Totti" wrote:

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.