Simple formula to return every even Friday

[LinuxMint]

I cannot figure this out for the life of me. I have scoured the interwebs looking for a simplistic formula that doesn’t use the SumProduct function and the double minus sign, and cannot find one that meets the needs of the spreadsheet I have designed. I wonder if a solution can be created from the following formulae:

=NOW()

in cell B2

=IF(ISODD(WEEKNUM(B2)),WEEKNUM(B2)+14,B2)

=IF(WEEKDAY(B2)+1=6,"Tomorrow",IF(WEEKDAY(B2)+1=6,B2+1,IF(WEEKDAY(B2)+2=6,B2+2,IF(WEEKDAY(B2)+3=6,B2+3,IF(WEEKDAY(B2)+4=6,B2+4,IF(WEEKDAY(B2)+5=6,B2+5,IF(WEEKDAY(B2)+6=6,B2+6,B2)))))))

as well as maybe workdays.intl funtion to specify the week beginning on Friday.

I have uploaded a copy of the spreadsheet I am trying to create this in.

These 3 formulae reside in cells B2 thru B5.

Any assistance is very appreciated.

Template.ods (38.2 KB)

[LinuxMint]

I arrived at a solution with the help of a friend. The formula is

=IF(AND(IF(ISEVEN(WORKDAY.INTL(A2,1,"1111011")),WORKDAY.INTL(A2,1,"1111011")+7,WORKDAY.INTL(A2,1,"1111011")),WEEKDAY(A2)=6),"Today!",IF(ISEVEN(WORKDAY.INTL(A2,1,"1111011")),WORKDAY.INTL(A2,1,"1111011")+7,WORKDAY.INTL(A2,1,"1111011")))

where A2 is the source date. This formula will return a value of every Friday that falls on an even numbered week, and if it’s the day of, returns a value of “Today!” (without quotes), and adds 7 days if the Friday falls on an odd-numbered week.