days360 convention

[jonny_1980]

Hi, i want to know the future dates based on the days360 convention

for example if i have 20/02/2007, how can i get the days in 180 days based on the days 360 convention?

Adding 180 to the above gives 19/08/2007, when i want 20/08/2007, then 20/02/2008 etc etc....

Thanks

J

 

[GlennUK]

How about:

=DATE(YEAR(E4),MONTH(E4)+6,DAY(E4))
?
As it is 6 "months" on, ( 180 = 6 x 30 standard months of a 360 day year )