0
How do you get Excel to run dates consecutively for a payment schedule?
Wiki User
∙ 10y ago
Put the first date in manually. You could then use a formula to do the subsequent dates, by adding the number of days you want. So if the first date was in cell A2 and in A3 you wanted one day later, you would have:
=A2+1
For a week later, you would have:
=A2+7
You could also use the Fill Series option that Excel provides, having selected the range of cells that you want to fill.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
Can you use the PMT function in Excel to display dates in many different formats?
The PMT function returns the payment amount for a loan, so it has nothing to do with how dates are displayed. It returns numbers.
Does Excel store dates and times using text?
No. Dates and times are stored as numbers in Excel.
What is a project schedule?
A Project Schedule is a list of dates defining the start and end dates of project activities.
Can you format dates in Excel?
yes
What Excel property help to design date in style?
Formatting. There are many ways of formatting dates in Excel.
When is the beginning of time in Excel?
In terms of dates, computers usually start dates for the 1st of January 1900. This is the way it works in Excel. For times, it starts at 00:00.
What is a meeting schedule template?
A meeting schedule template is an agenda that is used to schedule things such as appointments, or in this case, meetings. It includes dates and/or times.
What are the release dates for The Schedule - 1997?
The Schedule - 1997 was released on: USA: 29 October 1997 (premiere)
What are the game dates for the Dallas cowboys 2009-2010 season schedule?
The schedule has been released, but the dates and times have yet to be announced. The schedule should be finalized within the next month or so. Tickets are already on sale, however.
The default alignment for dates in MS Excel is?
Dates align to the right, because they are a type of number.
Indy dates 2008?
A little late for the 08 schedule, but with the link below, you can find the 09 IRL schedule.
What are the release dates for Right on Schedule - 2011?
Right on Schedule - 2011 was released on: USA: December 2011 (internet)
