Quick Links
Home
. . Introduction
. . Why Business Functions
. . Whats New
. . For Property People
. . . . Why For Property
. . . . PCS Seminar
. . Why Free
. . Awards
. . Key Users
. . Forum
. . Excel 12
Products
. . Overview
. . Business Functions
. . . . Summary
. . . . Function Selector
. . . . Function Finder
. . . . Trace
. . . . Help
. . . . Function Examples
. . . . Tutorials
. . . . Monte Carlo
. . . . GoalSeek
. . . . Utilities
. . . . Callable from VBA
. . . . Array Functions
. . . . CashFlow Administrator
. . . . Select Function
. . . . Number Formats
. . . . Functions Overview
. . CashFlow Administrator
. . SelectFunction
. . NumberFormats
Services
. . Services Overview
. . Bespoke Model Development
. . Implementation Assistance
. . Custom Editions
Download
Reference
. . Date Increment family
. . . . DpY
. . . . DpM
. . . . DpD
. . . . DpP
. . . . PrevDateSeq
. . . . NextDateSeq
. . . . PrevDateList
. . . . NextDateList
. . . . NextDateCombine
. . . . DatePer
. . . . EDateBF
. . . . DateSeq
. . . . DateSeqCombine
. . Function Categories
. . Function Families
. . Data Types
. . Variables
. . Topics
. . Features
. . Version History
. . Technical
Forum
Templates
. . Templates Home
. . Loans
. . Interest Rates
. . Finance
. . Math and Stats
. . Budgeting
. . Dates
. . Accounting
. . Real Estate
. . Real Estate (UK Specific)
. . Petroleum Economics
. . Techniques
. . Non Business Functions
Resources
. . Resources
. . Bookshop
. . Support
. . Tips & Articles
. . . . Tips
. . . . Business Functions
. . . . Excel
Company
. . Company
:: Reference
:: Date Increment family
:: NextDateSeq
Home
Introduction
Why Business Functions
Whats New
For Property People
Why Free
Awards
Key Users
Forum
Excel 12
Products
Overview
Business Functions
CashFlow Administrator
SelectFunction
NumberFormats
Services
Services Overview
Bespoke Model Development
Implementation Assistance
Custom Editions
Download
Reference
Date Increment family
Function Categories
Function Families
Data Types
Variables
Topics
Features
Version History
Technical
Forum
Templates
Templates Home
Loans
Interest Rates
Finance
Math and Stats
Budgeting
Dates
Accounting
Real Estate
Real Estate (UK Specific)
Petroleum Economics
Techniques
Non Business Functions
Resources
Resources
Bookshop
Support
Tips & Articles
Forum
Company
Date Increment family
Summary
DpY
DpM
DpD
DpP
PrevDateSeq
NextDateSeq
PrevDateList
NextDateList
NextDateCombine
DatePer
EDateBF
DateSeq
DateSeqCombine
[Categories]
[Families]
[Data Types]
[Variables]
[Topics]
NextDateSeq
(
TheDate
,
AnnDateSeq
, [
SpecificDates
])
Next Date in the Sequence
Pro
Features
Next...
Next Date
...Seq...
Using Date Sequence
Whats good or unique about it
You have complete flexibility over the dates in the sequence - they don"t have to be regularly spaced.
The function also accepts a
BusDaySwitch
which means that the date can be made to slip to the next Business Day.
Example
NextDateSeq.xls
Templates
This function features in the following downloadable spreadsheet template(s):
loan_mortgage_extrapayments.xls
max_loan_mortgage.xls
simplecashflow.xls
whybusinessfunctionsforproperty.xls
steppedrent.xls
loan_property.xls
simpledcfanalysis.xls
loan_amortisation_with_loanx.xls
loan_schedrep.xls
loan_rollup.xls
loan_mortgage.xls
simplebondissue.xls
constructionloan.xls
depreciation_pool.xls
rentroll_office.xls
loan_mortgage_matcheddebtservice.xls
dcfleaseappraisal.xls
simplerentroll.xls
property_loan.xls
real_estate_math.xls
Any comments on this documentation? Send us your suggestions below.
Your Email Address (required)
Subject
Message
See Also
DescribeBD
231