Formula?

[Kirstym1918]

Hi all,

I am setting up a calendar / planner on excel at the moment and I need the exact same text that I have typed into the first sunday cell to repeat on each every other sunday cell but at 9 weekly intervals.

Anyone any ideas?

Much Appreciated

 

[oldbrewer]

if this date minus first date is equal to 63 or 126 or 189 or 252 or 315 then B12 or whatever cell ref is

=if(or(..........)),then....

 

[Kirstym1918]

OK, still not achieving what I thought I could with the way this planner is going to work so I have had to rethink things, Do you know a formula I could use for the following

If A2 matches D2 and B2 matches I2 then return B1

Sorry I'm not great with excel only know basic formats, trying to self teach myself or at least with the help of the members of this board, I really must go on a course or something

 

[Joe4]

If A2 matches D2 and B2 matches I2 then return B1

Try:

=IF(AND(A2=D2,B2=I2),B1,"")

 

[Kirstym1918]

Works a treat and so simple, I over think things far too much.

Thanks

 

[Joe4]

You are welcome.

 

[Kirstym1918]

Hi

How do I get the formula to look in B7:J7 instead of just the one cell? It returns value when I put

=IF(AND('PMI Schedule'!$A7=$D9,'PMI Schedule'!$B7:J7=$P$2),$B$1,"")

=IF(AND('PMI Schedule'!$A7=$D9,'PMI Schedule'!$B7=$P$2),$B$1,"")​

 

[Joe4]

Try:

[COLOR=#222222][FONT=Verdana]=IF(AND('PMI Schedule'!$A7=$D9,COUNTIF('PMI Schedule'![/FONT][/COLOR][COLOR=#FF0000][FONT=Verdana]$B7:J7,$[/FONT][/COLOR][COLOR=#222222][FONT=Verdana]P$2)>0),$B$1,"")[/FONT][/COLOR]