View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Squid[_2_] Squid[_2_] is offline
external usenet poster
 
Posts: 17
Default Calculating Dates in VBA

I want to write some code that will calculate a date. I
need to calcuate an expiration date. The expiration date
will always be 1 year minus a day from the effective
date. So if the effective date = 6/1/2003, then the
expiration date = 5/31/04. I can do this pretty easily
within an excel worksheet, but I would like this to
happen with code.

Thanks
Mike