View Single Post
  #1   Report Post  
Old May 4th 12, 04:27 AM
KellyJane KellyJane is offline
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 1
Default Autopopulating a date

I need to autopopulate a future date for example;
I have a date in A1, and I want B2 to automatically give me the date 3 months from the date in A1. I have another date in C1 and I want to automatically populate the date 6 months later in D1.

I want to be able to enter different dates in the A column with the corresponding date to follow in the B column automatically.

Can anyone help?