Making payments correspond to correct date

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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!
 
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
 
Back
Top