Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making payments correspond to correct date
Hello,
This may be a basic question, but any help is greatly appreciated! I have created a calendar which populates the correct dates/days when a date is entered in a start cell. I am using it to display when certain bills/payments/etc. are due and I am trying to make it move the payments to the correct dates when a new month is entered. Example: In November, Payment A is due on Monday Nov. 10. But in December, Payment A will be due on Wednesday Dec. 10. Is there any way to make the data automaticly populate in the correct cells when a new month is entered? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making payments correspond to correct date
If you just want the cell to display the month and day, and in the bill
example you gave, the day is always the same from month to month for each bill, then the formula is simple: =TEXT(DATE(YEAR(A1),MONTH(A1),10),"mmm d") Assuming that the start cell is cell A1, the formula extracts the year and the month from the start cell and assigns the day to "10". The DATE function converts it to a real date that Excel recognizes (instead of just text), and then the TEXT function formats the data to be displayed as the three letter abbreviation for the month and the day value. Example: The start cell is A1 and the forumla above is in B3: A B 1 12/1/2008 2 3 Bill 1 Dec 10 "Chris" wrote: Hello, This may be a basic question, but any help is greatly appreciated! I have created a calendar which populates the correct dates/days when a date is entered in a start cell. I am using it to display when certain bills/payments/etc. are due and I am trying to make it move the payments to the correct dates when a new month is entered. Example: In November, Payment A is due on Monday Nov. 10. But in December, Payment A will be due on Wednesday Dec. 10. Is there any way to make the data automaticly populate in the correct cells when a new month is entered? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping the correct cells when making a formula? | Excel Worksheet Functions | |||
How do make a line correspond to date | Charts and Charting in Excel | |||
How do I calculate after making 12 payments of my mortgage | Excel Worksheet Functions | |||
HAVE A COLUMN OF DATE PAYMENTS ARE DUE DATE CHANGES TO 01/00/1900 | Excel Discussion (Misc queries) | |||
Making Excel Calculate In Correct Order | Excel Discussion (Misc queries) |