HELP! Formulas assistance

[Roo007]

i have an excel formula below that i need to add a column to after each day of the week,. How do i write/adjust the formula to give me what i need?
=IF(MONTH($K$6)<>MONTH($K$6-(WEEKDAY($K$6,1)-($AU$3-1))-IF((WEEKDAY($K$6,1)-($AU$3-1))<=0,7,0)+(ROW(K8)-ROW($K$8))*7+(COLUMN(K8)-COLUMN($K$8)+1)),"",$K$6-(WEEKDAY($K$6,1)-($AU$3-1))-IF((WEEKDAY($K$6,1)-($AU$3-1))<=0,7,0)+(ROW(K8)-ROW($K$8))*7+(COLUMN(K8)-COLUMN($K$8)+1))
You help is greatly appreciated!!!!

 

[Roo007]

Thank you Mike for all your help, this is exactly what I needed!!! Bless you, you're a life saver!

 

[ukmikeb]

Re; your recent PM
If you are considering implementing the formula I mentioned in post #10 as resident in AM8, for example purposes, the number of changes required as you progress through each month would be too many to make it a viable proposition.

I am sorry but that is due to the rigid structure that the developer of the calendar imposed on his product.

 

[Roo007]

No I'd like to use what you had in the XL file . Applied to every month. Can that be done?