Can it be done ??

[snoozee]

Hi

Now I'm not sure where to start so here goes

I have a spreadsheet that has the days of the month split out Mon-Sun and i have used a formula to automatically put in the correct dates of the month above the correct day e.g. if the 1st May was a Wednesday then 01/05/2018 would appear above 'Wednesday' and the Monday and Tuesday would have no date above them for that particular week - hope that just made sense.

What i need is if the week day showing is not part of that 'week' then the relevant cells are pre populated with NA or something similar.

Is this possible ??

 

[snoozee]

I've tried adding to my existing If statement that is in the same cell yet i'm getting the #VALUE ! error


=IF(B6<>DATE(dd,mm,yyyy),CHAR(215),IF(COUNTIF(B8:B13,"Y")=6,CHAR(80),IF(AND(COUNTIF(B8:B13,"")=6,B6>$A$4),CHAR(144),IF(COUNTIF(B8:B13,"Y")<>6,CHAR(209)))))

 

[steve the fish]

Im struggling to visualise what it is you want and judging by the lack of replies maybe everybody else is too. It may be better in this instance to copy a sample of what you want and paste it here.