Excel help

BossHogg · Nov 6, 2008

A member of another forum has a query over excel, can anyone help?

OK I have a spreadsheet thing which amounts to when the team members need their car park passes renewed (though annually, they are all at different times).

What I want to be able to do is have a column, for instance Column D, listing when the pass was issued - say 05-11-08, this stays fixed. On the 5th November, the next column, Column E, now needs to update itself to 05-11-09 (when the pass expires). Next year, that same Column E needs to update itself again to 31-10-10.

Can this be done?
Click to expand...

CutLunchCommando · Nov 6, 2008

Does it need done once when it is first created or will it need to be updated/amended regularly with the amendmenst propogating automatically?

The_Snail · Nov 6, 2008

ex_monkey said:

A member of another forum has a query over excel, can anyone help?

OK I have a spreadsheet thing which amounts to when the team members need their car park passes renewed (though annually, they are all at different times).

What I want to be able to do is have a column, for instance Column D, listing when the pass was issued - say 05-11-08, this stays fixed. On the 5th November, the next column, Column E, now needs to update itself to 05-11-09 (when the pass expires). Next year, that same Column E needs to update itself again to 31-10-10.

Can this be done?
Click to expand...

Click to expand...

I'm sure it can, but I have been playing beerpong and I don't have Excel on my lappy. I'll have a look tomorrow at work and PM you if I work it out. Unless some other clever bugger susses it first.

Bravo_Zulu · Nov 6, 2008

Having a play with excel 08, formatting the cells to date (DD/MM/YY), then using a formula to add months seems to work. Not sure about earlier editions of office; having a play often works, I find.

Litotes · Nov 6, 2008

Make certain you have the correct formatting applied to the cells, and then the second cell (B4) has "=a4+365" in it. Apply the date in A4 and Bob's your Uncle!

You might have to fiddle around for leap years, but there is the basic answer!

Litotes

BossHogg · Nov 6, 2008

Cheers, I'll post a link on the other forum to this thread so the user can see the answers for themselves. Many thanks

CityBanker · Nov 6, 2008

PM'd you.

Log in or Sign up

Excel help

Welcome to the Army Rumour Service, ARRSE

The UK's largest and busiest UNofficial military website.

BossHogg

CutLunchCommando

The_Snail

Bravo_Zulu

Litotes

BossHogg

CityBanker

Excel help

Welcome to the Army Rumour Service, ARRSE

The UK's largest and busiest UNofficial military website.

Useful Searches