J
John
Hi. Just wondered if someone brainy can help me with two formulas? The
first one I was wanting to enter todays date in a cell i.e. =today()
I also would like to have the date of my birthday next year 08/01/2006
in another cell.
I then want to take away todays date from that of my birthday and have
it formatted so it gives the number of days to go until my birthday.
So each different day I open the spreadsheet it will say one day less.
Maybe there is something that can be done with some sort of Count
query? Not being a wizz with formulas though I'm not sure the best way
to do this one.
The second formula I wish to do is a conversion of fuel consumption.
In the UK we calculate our fuel economy in MPG Miles per Gallon. In
Europe they like to do it a new metric way in litres needed for every
100 Km which nobody understands or can relate to.
A lot of car manufacturers are now just using the Euro way so it is a
pain to work out what the fuel consumption figures are for different
car models.
So if a car needs 7 litres of fuel for every 100 Km, I would like to
work out with a formula how many Miles per gallon consumption that
would equate to. Here in the UK it is 4.55 litres to every gallon. I'd
like to have it so I can enter the number in a cell and the next cell
it works it out in. I'm not precisely sure how many KM there are in a
Mile, but I'm sure someone in here might know?
Appreciate any help with these formulas
Cheers
John
first one I was wanting to enter todays date in a cell i.e. =today()
I also would like to have the date of my birthday next year 08/01/2006
in another cell.
I then want to take away todays date from that of my birthday and have
it formatted so it gives the number of days to go until my birthday.
So each different day I open the spreadsheet it will say one day less.
Maybe there is something that can be done with some sort of Count
query? Not being a wizz with formulas though I'm not sure the best way
to do this one.
The second formula I wish to do is a conversion of fuel consumption.
In the UK we calculate our fuel economy in MPG Miles per Gallon. In
Europe they like to do it a new metric way in litres needed for every
100 Km which nobody understands or can relate to.
A lot of car manufacturers are now just using the Euro way so it is a
pain to work out what the fuel consumption figures are for different
car models.
So if a car needs 7 litres of fuel for every 100 Km, I would like to
work out with a formula how many Miles per gallon consumption that
would equate to. Here in the UK it is 4.55 litres to every gallon. I'd
like to have it so I can enter the number in a cell and the next cell
it works it out in. I'm not precisely sure how many KM there are in a
Mile, but I'm sure someone in here might know?
Appreciate any help with these formulas
Cheers
John