LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by zvkmpw View Post
I need to set up a series of recurring dates in excel for various
clients. They will be recurring in increments of every 2 weeks or every
3 weeks etc. I'll want to use it for easy access to the date I need to
schedule the next appointment since I'll do that at the end of every
month for the following month. So if my June appointment for client X is
on the 19th the next will be July 10th then 17th and so on....how do I
calculate that? Thanks!


Dates in Excel are just whole numbers. Add 14 for two weeks later; 21 for 3 weeks later; etc.

Maybe I'm missing the point, though. The question doesn't seem to specify when to use how-many weeks.
I think I was making it a bit too complicated. Thanks, that worked!
 
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
Comparing Date Ranges in one Table to Date Ranges in another Table Mike C[_5_] Excel Programming 0 December 21st 09 10:30 PM
Can you have 2 date ranges in one row on an Excel Gantt chart? KAREN_W Charts and Charting in Excel 8 December 9th 07 09:19 PM
excel date ranges Skibee Excel Discussion (Misc queries) 4 November 9th 07 12:53 PM
Generating Date Ranges in Excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 4th 07 05:33 PM
Recognizing Date Ranges in excel [email protected] Excel Programming 1 July 22nd 05 06:00 PM


All times are GMT +1. The time now is 04:24 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"