Calculating a date

[MarkoBrit]

Hi I have a spread sheet which shows employees (trainees etc) who are under 18.
In cell B2 I have thier DOB. Then in C2 I want a formula that returns the date of when they would reach 18. Anyone know how to do that?

 

[alansidman]

Data Range
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

EE​

[/TD]
[TD]

DOB​

[/TD]
[TD]

18​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

A​

[/TD]
[TD]

37411​

[/TD]
[TD]

=B2+(18*365.25)​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

b​

[/TD]
[TD]

37803​

[/TD]
[TD]

=B3+(18*365.25)​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

c​

[/TD]
[TD]

38204​

[/TD]
[TD]

=B4+(18*365.25)​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

d​

[/TD]
[TD]

37141​

[/TD]
[TD]

=B5+(18*365.25)​

[/TD]
[/TR]
</tbody>[/TABLE]


Because I am showing this as formulas, the DOB shows numerical and not date format. Should not make a difference when you do your actual file.

Data Range
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

EE​

[/TD]
[TD]

DOB​

[/TD]
[TD]

18​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

A​

[/TD]
[TD]

6/4/2002​

[/TD]
[TD]

6/3/2020​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

b​

[/TD]
[TD]

7/1/2003​

[/TD]
[TD]

6/30/2021​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

c​

[/TD]
[TD]

8/5/2004​

[/TD]
[TD]

8/5/2022​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

d​

[/TD]
[TD]

9/7/2001​

[/TD]
[TD]

9/7/2019​

[/TD]
[/TR]
</tbody>[/TABLE]


You may want to change the multiplier to 365 instead of 365.25

 

[Fluff]

How about

Excel 2013/2016
	A	B	C
1	Name
2	Tom Pearce	29/04/2019	29/04/2037
3	Bill Brewer	15/03/2011	15/03/2029
4	Jan Stewer	25/08/2012	25/08/2030
5	Peter Gurney	15/06/2013	15/06/2031
6	Peter Davy	15/06/2010	15/06/2028
7	Dan'l Whiddon	22/05/2000	22/05/2018
8	Harry Hawke	11/03/2005	11/03/2023
Engine

Cell Formulas
Range	Formula
C2	=EDATE(B2,216)

 

[MarkoBrit]

Excellent ! Thanks