LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 791
Default Calculation of future dates

Hello,

I have a list of clients with dates of our first contact, e.g.
J. Smith 2008 Apr 12
K. Brown 2008 June 14
A. Black 2008 July 03
S. Long 2008 July 24
J. Doe 2008 Aug 01
A. Miller 2008 Sept 06

Then I need to contact them every 3 months for 2 years (e.g. both A. Black
and S. Long should be contacted in Oct 2008, Jan, Apr, Jul and Oct 2009, Jan,
Apr and finally July 2010).
How can I make Excel to put dates of prospective contacts - I need the month
and year only - automatically as soon as the first contact date is entered
for each of them?
I would like to enter the name in column A, first contact date in column B,
and have prospective dates appear automatically in columns C-J.

Then, I would like to know the number and kind of each contact for a given
month.
I imagine a worksheet with contact names in rows (3mo, 6mo, 9mo, 1yr etc.)
and months in columns (Oct 08, Nov 08, Dec 08, Jan 09 and so on).
For example the column "Jan 09" would have a "1" in 9mo contact cell, a "2"
in the 6mo contact cell and a blank 1yr contact cell. How to do it?

I am sorry if my 2 questions are too long, I tried to explain as clear as
possible.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Future date Calculation Qazi Ahmad Excel Discussion (Misc queries) 8 May 27th 07 12:24 PM
future value calculation in excel reichertj Excel Worksheet Functions 3 April 1st 07 05:28 PM
Future Value Calculation SJT Excel Discussion (Misc queries) 2 September 7th 06 02:06 AM
future dates kevrgallagher Excel Worksheet Functions 2 July 14th 05 05:36 PM
future dates kevrgallagher Excel Worksheet Functions 4 July 12th 05 03:47 PM


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"