date

[afdmello]

Hi Folks,

I have a date october 12, 2016 written as 12-10-16 . Which formula will give me a date 6 months ahead?

Afd

 

[Joe4]

Is it entered as Text, or as a Date with a Custom Format?
If you aren't sure, use this formula to test.

If the value is in cell A1:
=ISNUMBER(A1)

If it returns FALSE, it is Text
If it returns TRUE, it is a Date

 

[Joe4]

If it is a Date, simply use this formula, and the same Custom Format you are using on that cell (dd-mm-yy):
=EDATE(A1,6)

If it is Text, use this formula:
=TEXT(EDATE(DATE("20" & RIGHT(A1,2),MID(A1,4,2),LEFT(A1,2)),6),"dd-mm-yy")

 

[SQUIDD]

=DATE(YEAR(H6), MONTH(H6)+6, DAY(H6))

dave

 

[Joe4]

=DATE(YEAR(H6), MONTH(H6)+6, DAY(H6))

That is a another alternative to using EDATE. Just note that it will only work on Date entries, and not Text ones (see my first reply).