From: Chris waller on 21 Mar 2010 10:31 I have a Spreadsheet that contains a column of dates (birthdays and anniversarys)in the dd/mm/yyyy format. Across row 1 I have the years 2010, 2011, 2012 etc. At the intersection of the two I wish to insert a formula that will calculate the age or the anniversary. I would be grateful for any help. Thanks in advance.
From: Fred Smith on 21 Mar 2010 12:12 See your other post. Regards, Fred "Chris waller" <Chriswaller(a)discussions.microsoft.com> wrote in message news:0AFDC0A0-1B1B-47DE-AD7B-E77B64E995AB(a)microsoft.com... >I have a Spreadsheet that contains a column of dates (birthdays and > anniversarys)in the dd/mm/yyyy format. Across row 1 I have the years 2010, > 2011, 2012 etc. At the intersection of the two I wish to insert a formula > that will calculate the age or the anniversary. I would be grateful for > any > help. Thanks in advance.
|
Pages: 1 Prev: Conditional Format Fragmentation Next: Calculating How Old Someone Will Be in a certain year |