Thread: Add years NOT days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Coza Coza is offline
external usenet poster
  
Posts: 38
Default Add years NOT days
In the following formula, J4 is (dddd dd mmmm yyyy) and H4 is (2)
[Representing Years].
=IF(J4<"",J4+H4,"")

Currently it ADD's Days, how can i convrt the formula to ADD years ?


Corey....



Reply With QuoteReply With Quote