# date

#### afdmello

##### Board Regular
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

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### 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

Last edited:

#### 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

##### Well-known Member
Code:
``=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).

Replies
0
Views
77
Replies
3
Views
162
Replies
0
Views
617
Replies
3
Views
51
Replies
4
Views
225

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,837
Messages
5,833,915
Members
430,244
Latest member
Ireland1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back