Date Time Formulas

[beanyboy7]

Ok this goes out to all of the Excel gods out there.

I have to find a away to generate future dates in 15 day increments.

For example I have a list of our customers and their call dates. I need to generate monthly 15 day increments to show when they need to be called again, into perpetuity. I tried using some kind of yearly frac formula, but with out an end date it doesn't work. I also tried applying the date serial number formula and manipulating that. Also to no avail. SO now I must turn to the Great wizards of Excel and see if they can share any of their arcane knowledge and divine wisdom to solve my problem.


Here's how it looks

Name Date of Purchase Future Call Date (needed)

John Smith 2-20-04 3-6-04
Robert Jones 2-05-04 ???????
Billy Holden 2-15-04 ????????




Thanks again and you guys rock the house

 

[Aladin Akyurek]

It's just:

=B2+15

 

[beanyboy7]

Oh Duh!



I made more of it than I should have.

That's just like a German to over think things.

Thanks again

Ben