# Is there a way to make a cell visible but ignored?

I have dates set in a column and I drop down the formula so that each cell is getting filled automatically, but the problem is that I need a blank cell between each weeks, can’t seem to find how even if I do believe it must be really easy. For now I just do it manually. Would be like making the dropdown gesture skip specified cells.

Hi

If I understand the question you can:

• Enter the initial date (to A2 in this example),
• Enter the following formula in A3 `=IF(A2="",A1+1,IF(WEEKDAY(A2)<>1,A2+1,""))`
• Fill down

[EDIT]new version (no sunday) weekend.ods

Regards

Seems like it should work, but when I try it I always get error:501 no matter what I do. I’ve tried it in a completely new sheet and followed your instructions. I do use the French version, but apart from the “weekday” part I can change everything so it can be compatible. Thank you for your help.

You need to adapt the separator according to `Tools` `Options` `Calc` `Formula` `Separators`. In French may be use `;` instead of `,`

Damn I feel dumb. I’m almost there, I think I’ve found how to replace weekday, but now I get the error 511 saying that I’m missing something. Here’s a screen: http://puu.sh/ikztA/a5e0a8ed3b.png

In french `=SI(A2="";A1+1;SI(JOURSEM(A2)<>1;A2+1;""))`

It finally works, thanks a lot. If that’s not too much to ask is there a way to make it so that sunday doesn’t appear? Do tell if I’m asking too much.

Use (in french environment) `=SI(C2="";C1+2;SI(JOURSEM(C2)=7;"";C2+1))`