Hello this is probably easy but I can't get my head around it.
I need a formula in a cell that will give me the start of the current week. So if the start of the week is Monday 11th October then on Tuesday to Sunday of next week the date Monday 11th October will appear but on Monday of the following week Monday 18th October will appear and it will stay like that until the end oif the week and so on. Probably something to do with TODAY() but I have tried various little IF formulas but cannot get them to work.
I'd appreciate any help
I need a formula in a cell that will give me the start of the current week. So if the start of the week is Monday 11th October then on Tuesday to Sunday of next week the date Monday 11th October will appear but on Monday of the following week Monday 18th October will appear and it will stay like that until the end oif the week and so on. Probably something to do with TODAY() but I have tried various little IF formulas but cannot get them to work.
I'd appreciate any help