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! |
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! |
All times are GMT +1. The time now is 09:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com