View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TonyL TonyL is offline
external usenet poster
 
Posts: 17
Default Date calculation problem

Cell A1 contains a date & I want to calculate to the end of that of that year
period i.e. cell A1 contains 01/04/2007 & I want cell A2 to be 31/03/2008
(ddmmyyyy format). =A1+364 won't do as this does not take into account leap
years. TIA
--
Tony