John,
As Kevin said in the New Users group, your formula should not give Excel any
problems. What happens when you say it does not work? Do you have a blank
cell? Or rather what looks like a blank cell, ie try changing the false part
of your formula to say, "Error" instead of "" and see if it returns that,
then post back.
Incidentally I realise that three years that contain a leap year are 1096
days but if there is no leap year, or rather no February 29th in the period,
then it will be three years and one day. It would be better to add the time
by the formula:
=DATE(YEAR(F22)+3,MONTH(F22),DAY(F22))
Regards
Sandy
