View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bladerunner926 bladerunner926 is offline
external usenet poster
 
Posts: 1
Default dates count till elapsed

On a worksheet I have a date a person has passed a course say in cell a1
The course is valid for 5 years only before a person needs to requalify
in cell a2 I want to be able to calculate the time left between cell a1 and
5 years down the line and have it counting down
does anyone know of a formula etc how I can do this
Many Thanks
--
bladerunner926