date formula

[Trevor3007]

good afternoon,

is there a formula to show the date of the 1st friday of the next month?

I tried using =CEILING(EOMONTH(A2,-1)-5,7)+6

but it did not work as I wanted. In cell a2 date 3/9/18 returns 7/9/18...but I need it to show the following 1st friday of the next month which should be 5/10/18.

also the date in A2 will change weekly & therefore the 1st friday of the next month date should always be 5/10/18 or 2/11/18 and so forth .

thank you for all your help
KR
Trevor

 

[Fluff]

try
=CEILING(EOMONTH(A2,0)-5,7)+6

 

[Trevor3007]

try
=CEILING(EOMONTH(A2,0)-5,7)+6

hi fluff,

once again you have sorted my issue.


thank you :}

KR
Trevor3007

 

[Fluff]

Glad to help & thanks for the feedback

 

[Trevor3007]

Glad to help & thanks for the feedback

hi Fluff,

credit , when credit is due :}

KR
Trevor3007