View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dolivastro@gmail.com is offline
external usenet poster
 
Posts: 46
Default Todays date plus 3 months & less 3 months

Use DateAdd, like this:

DateAdd ("m", 3, now())
DateAdd("m", -3, now())

HTH,
Dom



Les Stout wrote:
Hi, i can get todays date but need to add 3 months to it and the other
way too.

Any help would be much appreciated.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***