There is no simple answer to that, as it will depend on various factors. Each project is different. Without all of those factors, it is not possible to start to answer the question. It could be done in Excel, but a better application for managing a project is Microsoft Project.
You can easily do this with Microsoft Excel or OpenOffice's spreadsheet module.
no
To use the 30/360 day count calculator in Excel for accurate interest payment calculations, input the start date, end date, and the interest rate. Excel will automatically calculate the number of days between the dates based on the 30/360 day count convention, allowing you to determine the interest payment amount more precisely.
a serial value to the date
numerical
Friday. There are lots of ways to calculate this, but I just typed the date into MS Excel and formatted the cell to show the day of the week.
Format / Cells / Date
You select a cell, and type:= now()You can also make calculations involving the current date/time. For example, if in some cell you have a fixed date, you can use a formula involving now() to calculate how many days have passed from that date.
date
ask me plz...
You do not. Excel does not record the change date of an individual cell.
You can use Excel to calculate and track your car loan payments by setting up a loan amortization schedule. Input the loan amount, interest rate, loan term, and start date in Excel. Then, use the PMT function to calculate the monthly payment. Create a table to track each payment, including the principal and interest portions. Update the table each month to keep track of your remaining balance and progress on the loan.