Date calculations using functions

[Guest]

I need to perform the following calculations but am having problems, HELP!

given a date, ie: june 4 2001, I need a formula/function to show dec 31 of
the year of the previous date. I then need to add a number of years ie:
4years.

Any suggestions?

 

[Myrna Larson]

Four years from the previous Dec 31 is 3 years from Dec 31 of the current
year, so with the starting date in A1

=DATE(YEAR(A1)+3,12,31)

 

[Frank Kabel]

Hi
if you mean the december of the year before try:
=DATE(YEAR(A1)-1,12,31)

if you want to add years use
=DATE(YEAR(A1)+4,MONTH(A1),DAY(A1))

 

[M S-Greenaway]

Hi Sue

I may be able to help. However, the calculation of times and date varies.
Please send and more in-depth attachment and I will have a look at it

Thanks

Mikey