Excel help

Discussion in 'Gaming and Software' started by BossHogg, Nov 6, 2008.

Welcome to the Army Rumour Service, ARRSE

The UK's largest and busiest UNofficial military website.

The heart of the site is the forum area, including:

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

  2. Does it need done once when it is first created or will it need to be updated/amended regularly with the amendmenst propogating automatically?
  3. 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.
  4. 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.
  5. 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!

  6. Cheers, I'll post a link on the other forum to this thread so the user can see the answers for themselves. Many thanks :D
  7. PM'd you.