Discussion in 'Gaming and Software' started by BossHogg, Nov 6, 2008.
The heart of the site is the forum area, including:
A member of another forum has a query over excel, can anyone help?
Does it need done once when it is first created or will it need to be updated/amended regularly with the amendmenst propogating automatically?
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.
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.
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!
Cheers, I'll post a link on the other forum to this thread so the user can see the answers for themselves. Many thanks
Separate names with a comma.