Date+ returns #Num
kit wrote:
Hi
have the following date format in A1 - 12/15/05.
In b1 I want the date calculated as 6 months later, entered the following in
b1-
=DATE(,,A1+180), but it returns #NUM. Tried it as +6 but still same result
What am I doing wrong
Hi kit,
Try =date(year(A1),month(A1)+6,day(A1))
Be careful concerning :
* 6 months < 180 days
* 31 aug + 6 months is not 31 feb :o)
FxM
|