Excel 2007 : Calculate years, months, day

Originally Posted by sweep

Hi,

I think this is what you need:

=IF(A1="","-",EDATE(A1,120))

W0W thanks!!!!! it work!!!!! sir can you explain the two quotes? and how it works?

Originally Posted by jeffreybrown

The best way to learn what a formula is doing is to evaluate the formula.

Select the cell with the formula and seclet Alt + t,u,f

Then you can step thru what is happening.

For the EDATE function look in Excel help. 120 months divided by 12 equals your 10 years.

The first part of the formula says, If A1 does not equal anything "", the just put a - in the cell.

When you fill A1 with a date it is no longer "" so the formula proceeds to the second half, the EDATE function.

thank youy sir!!!! i get it now what the quotes do in excel...is possible also to use this in my problem 2?

this is the problem 2:

sir i have a problem again... sir is there a formula that if the cell is blank it will fill color grey or any color i want but if i type in a cell it fill color white....

Originally Posted by jeffreybrown

take a look at http://www.contextures.com/xlcondFormat01.html

for your problem3 please attach a workbook which will detail all three of your results

here is the attachment sir.... for my next post i will create a different thread title because admin staff send me a message (sorry)