Author Topic: How do I find some software to work out how many months between two dates?  (Read 3252 times)

Offline Weeford HoldcroftS

  • RootsChat Extra
  • **
  • Posts: 92
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
I am trying to find a way of working out the number of months between two dates. For example. If you have a marriage date and then the birth date of the first child it would be useful to know if the wedding was as a result of the happy news. Also it would be useful to know the months between the children to see if there were any longer gaps, ie through illness. Tried to do it in Excell but it is near imposible, any ideas.

Online BumbleB

  • RootsChat Marquessate
  • *******
  • Posts: 14,239
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: How do I find some software to work out how many months between two dates?
« Reply #1 on: Monday 08 June 15 19:37 BST (UK) »
My apologies but why would you need software to work out the number of months between events?  The number of days I might understand, but there are only 12 months in any year.  :-\ :-X
Transcriptions and NBI are merely finding aids.  They are NOT a substitute for original record entries.
Remember - "They'll be found when they want to be found" !!!
If you don't ask the question, you won't get an answer.
He/she who never made a mistake, never made anything.
Archbell - anywhere, any date
Kendall - WRY
Milner - WRY
Appleyard - WRY

Offline chempat

  • RootsChat Marquessate
  • *******
  • Posts: 8,553
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile

Offline km1971

  • RootsChat Marquessate
  • *******
  • Posts: 9,343
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: How do I find some software to work out how many months between two dates?
« Reply #3 on: Monday 08 June 15 20:34 BST (UK) »
Take three off the month and add one to the year to get nine months.

Ken


Offline KGarrad

  • RootsChat Marquessate
  • *******
  • Posts: 25,981
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: How do I find some software to work out how many months between two dates?
« Reply #4 on: Monday 08 June 15 22:41 BST (UK) »
In Excel, assume your dates are in cells A1 and A2.

The number of months can be found by the Formula =Month(A1-A2).
Garrad (Suffolk, Essex, Somerset), Crocker (Somerset), Vanstone (Devon, Jersey), Sims (Wiltshire), Bridger (Kent)

Offline larkspur

  • RootsChat Marquessate
  • *******
  • Posts: 3,074
  • Tracing myself back to better people.Or maybe not!
    • View Profile
Re: How do I find some software to work out how many months between two dates?
« Reply #5 on: Tuesday 09 June 15 11:10 BST (UK) »
I tend to use my fingers  :P its always worked for me  ;D
AREA, Nottinghamshire. Lincolnshire. Staffordshire. Leicestershire, Morayshire.
Paternal Line--An(t)(c)liff(e).Faulkner. Mayfield. Cant. Davison. Caunt. Trigg. Rawding. Buttery. Rayworth. Pepper. Otter. Whitworth. Gray. Calder. Laing.Wink. Wright. Jackson. Taylor.
Maternal Line--Linsey. Spicer. Corns. Judson. Greensmith. Steel. Woodford. Ellis. Wyan. Callis. Warriner. Rawlin. Merrin. Vale. Summerfield. Cartwright.
Husbands-Beckett. Heald. Pilkington. Arnold. Hall. Willows. Dring. Newcomb. Hawley

Offline msr

  • RootsChat Aristocrat
  • ******
  • Posts: 1,256
    • View Profile
Re: How do I find some software to work out how many months between two dates?
« Reply #6 on: Tuesday 09 June 15 12:36 BST (UK) »
I see K Garrad gave a formula, but admit that I can't understand the need for one.

As mentioned, only 12 months in a year, and if you know the names of those and can add or take away numbers up to 10, oh go on, up to 12, nothing else is required - is it?

Maybe I'm thinking in too simple terms  :-\

Offline KGarrad

  • RootsChat Marquessate
  • *******
  • Posts: 25,981
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: How do I find some software to work out how many months between two dates?
« Reply #7 on: Tuesday 09 June 15 12:47 BST (UK) »
I see K Garrad gave a formula, but admit that I can't understand the need for one.

I gave the formula because OP said:
Tried to do it in Excell but it is near imposible, any ideas.

Just to prove it most certainly wasn't "near impossible"!! ;D ;D
Garrad (Suffolk, Essex, Somerset), Crocker (Somerset), Vanstone (Devon, Jersey), Sims (Wiltshire), Bridger (Kent)

Offline rosie99

  • RootsChat Marquessate
  • *******
  • Posts: 41,826
  • ALFIE 2009 - 2021 (Rosbercon Sky's the Limit)
    • View Profile
Re: How do I find some software to work out how many months between two dates?
« Reply #8 on: Tuesday 09 June 15 13:11 BST (UK) »
PAF5,  Rootsmagic & familytreemaker all have the facility to do this if you have access to any of them. 
The Date calculator is listed in all 3 under tools

Rosie
Census information is Crown Copyright, from www.nationalarchives.gov.uk