Plotting the date of first Friday by formula for the given year and month.

[thilag]

Hello Friends

Attached file name : <First Friday date finding.xlsx>
Attached file Version : 2010

I want to plot the date of first Friday by formula in yellow cell for the given year and month.

thanks in advance


thilag

[azumi]

Put in C3:

=DATE(TEXT(DATE(B3,1,1),"yyy"),TEXT(DATE(1,A3,1),"m"),1)-DAY(DATE(TEXT(DATE(B3,1,1),"yyy"),TEXT(DATE(1,A3,1),"m"),1))+8-WEEKDAY(DATE(TEXT(DATE(B3,1,1),"yyy"),TEXT(DATE(1,A3,1),"m"),1)-DAY(DATE(TEXT(DATE(B3,1,1),"yyy"),TEXT(DATE(1,A3,1),"m"),1))+2)

and formatted as dd-mmm-yyyy in custom formatted

Hope this helps

Azumi

[thilag]

Hello Asumi

Thanks & Thanks

thilag

[daddylonglegs]

Asumi's formula works for me.....but it's a little bit more complicated than you need. This formula will give the same results

=DATE(B3,A3,8)-WEEKDAY(DATE(B3,A3,2))