David S

I have a sheet with dates running down the list in column A I want to project 7 and 14 days on across. the sheet.

Cell A1 has Date in. I need formula for, to show date 7 days on and B1 7 days on from C1 ( or 14 days on from A1). however running down the sheet, if there is no data ( Date) in Cell A2 i need B2 and C3 to be blank

I NEED TO PROJECT A DATE 7 DAYS AND 14 DAYS

Cell A1 has Date in. I need formula for, A2 to show date 7 days on and A3 7 days on from A2 ( or 14 days on from A1.

Ok I have a list of names going down the sheet in column A lets say A1 A2 A3 A5 A7 A8 . I want Column B to show A1 =1 A2 =1 A3 =1 A4(no data) to show blank if no data but show 1 if data in cell and so on.

so at the bottom of column I can total the number like B20= Sum(B1:b19)

Hi , I have just Purchased A ViewSonic Mini PC( VOT125)

It is running windows . I plugged it in to my LG TV using HDMI Connection. Windows loaded up and the computer started up but the screen started flashing on and off at first it flashed about every 30 seconds for about half a second but then the flashed just got faster lasting longer? I have tried 4 different HDMI leads but nothing improves it. I also tried changing the screen resolution but this made no difference . Any one any Ideas what could be wrong? could it be that the TV screen is not compatible with this PC ( I can connect my HP Laptop to the TV no problem no flashing of the screen

thanks in anticipation

Can Raspberry pi run Windows?.

I have a 32gb SD card

Just had the first service on my 1 year old Ariston combi boiler. This boiler was installed by a gas safe installer.

The service guy said the pipe work is of insufficient diameter is he just trying to get cash out of me?

Ok full story for 25 years I had A gloworm boiler which was supplied from the gas meter by 22mm pipe which then reduced to15mm pipe some way from the boiler. I never had any problems with insufficient gas supply to boiler.

I then got a gas fire installed the fitters said that the pipe was to small so I paid to have all the gas pipe replaced with what they recommended, 22mm pipe. So the pipe runs at 22mm from meter then tees off towards gas fire, two meters on on this line it then reduces to15 mm which then reduces and then 8mm about 1.5 meter from fire and connects to fire at 8mm

. At the other branch of the t junction it carries on all the way to the combi boiler at 22mm.

So if these new boilers are suppose to be more flue efficient why is he telling me I need 28mm pipe?

Hi Just bought a Raspberry Pi with lots of programs preinstalled on SD card some of them are different internet browsers but when i plug it in using a RJ45 cable connected to my router it will not connect to the internet. I cannot find anything like the windows protocol to find the ip address so i can change it to match the router any help.

this is my first foray into linux.

I am 55 and I have some money in an Ecquitable life pension fund, I have not paid anything in to it since the crash, I was wondering if i could get at any of the fund now?

Hi I have A Saab 9-3 , The bonnet has gone very cloudy I have tried polishing it out but it makes no differance. is ther a product on the market to fix the problem or is it a respray job.

the paint is metalic and i think it is a varnish type over the top that has gon cloudy.

thanks

I am on forigen offshore vessel Entering the USA from Mexico. We have on board food and provisions for the crew. where can I find information online about what is permmitted and what need disposing off before entering a US Port.

Hi I have just bought a property that was advetised as freehold.

now that all the paperwork is done. it says I own the freehold and the leasehold.

I thought properties were one or the other. So my question is why do I need a leasehold if I own the freehold?

Hi I have a strange problem , when connecting my computer to TV using HDMI cable.

If i connect the HDMI cable I can get whatever is on my computer screen to show on the TV screen no problem but there is no sound. The only way I can get sound is if I first start a Movie or Music file then connect the HDMI cable. However this only last until the Movie finishes or the music selection has finished. if I want to watch another movie or another album, I have to remove the HDMI cable close any programs that play the files then reopen and reconnect the HDMI Cable.

I have looked in device manager and there are no conflicts and i have tried updating the sound drivers and HDMI drivers but it tells me i have the latest installed.

Can anyone tell me what is wrong

Thanks in anticipation

My laptop has 3 gb memory, a 2 gb and a 1 gb, it will take a maximum of 4 gb. I have just been to Crucial and they want to sell me a matched pair of 2 x 2 gb. How important is it to have matched pairs?

what problems could / would it cause if I were to just replace the 1 gb with a 2gb ?

Hi I want to connect speakers to my TV using the headphone jack connection, I require an amplifier between TV and speakers, The speakers are 8Ω each. My question is can anyone direct me to a suitable amplifier.

I am wanting to put these speakers in the bathroom ceiling and use the radio channels on the TV to pipe music.

If you were normal working people on average wages and you had come in to money, and had 100K to invest, what would you do with it? would you invest it for the future or blow the lot?