Assigned Specific Date

[prestigemnl]

I'm working on a Date of Payment Schedule but don't know the formula for this:

Reservation Date: Start of DP:
1st - 7th every 7th of the month
8th - 15th every 15th of the month
16th - 22nd every 22nd of the month
23rd - 30th/31st every 30th of the month (or 28th if February)

will refer as of =today()

Hope anyone can help me figure this out.

Many thanks.

 

[Latchmaker]

=if(day(today())<8,today()+sum(7-day(today())),if(day(today())<16,today()+sum(15-day(today())),if(day(today())<23,today()+sum(22-day(today())),if(month(today())=2,today()+sum(28-day(today())),today()+sum(30-day(today()))))))

 

[Latchmaker]

You can add this formula in the cell below the one above and fill down to show the future schedule dates
You will need to change the reference of B2 to reference the cell that you place the formula from above in.
If you place the formula above in B2 then paste this one in B3 you will not need to change anything.
=DATEVALUE(CONCATENATE(IF(MONTH(B2)=12,1,MONTH(B2)+1),"/",DAY(B2),"/",IF(MONTH(B2)=12,YEAR(B2)+1,YEAR(B2))))

 

[prestigemnl]

thank you very much!

 

[prestigemnl]

Another question.... for example i'd like to add how many months for the DP, what will i change in the formula?

 

[Latchmaker]

explain "add how many months for the DP"

 

[prestigemnl]

Please see link below for the illustration.

that's the pattern. i'd like to put any number of months (ex. 6) on A then B must show the date given (March 7, 2015) following the payment schedule.

https://www.dropbox.com/s/1wgf5zw74zz6py1/SAMPLE.jpg?dl=0

 

[prestigemnl]

hi again!
i have a bit of a problem about the formula, whenever i input month of january the concatenate formula appears #Value. and also when i input month of february, the concatenate also follows the end day of february that is the 28th. it suppose to be march 30th. hope you could help me.... thanks =)