automatic date calc

[Luigi802]

Per example below, this is really racking my brain! How could I make the "Due Date" if it's not in between the pay period, for example, since today is Jan 24th, the 1st 4 bills should read "Day"FEB"16" and the last 2 should still read Jan as they are withing the pay period.

[TABLE="width: 235"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 4"]Today is 1/24/16[/TD]
[/TR]
[TR]
[TD]Pay period[/TD]
[TD]1/22/16[/TD]
[TD]To[/TD]
[TD]1/29/16[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]Amount[/TD]
[TD]Due Date[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bill 1[/TD]
[TD]$650.00[/TD]
[TD]2/1/16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bill 2[/TD]
[TD]$200.00[/TD]
[TD]2/5/16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bill 3[/TD]
[TD]$65.00[/TD]
[TD]2/10/16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bill 4[/TD]
[TD]$50.00[/TD]
[TD]2/21/16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bill 5[/TD]
[TD]$300.00[/TD]
[TD]1/22/16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bill 6[/TD]
[TD]$25.00[/TD]
[TD]1/23/16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bill 7[/TD]
[TD]$85.00[/TD]
[TD]1/25/16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bill 8[/TD]
[TD]$40.00[/TD]
[TD]1/28/16[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Luigi802]

Per example below, this is really racking my brain! How could I make the "Due Date" if it's not in between the pay period,

What I mean to say is Per example below, this is really racking my brain! How could I make the "Due Date" automatically update to the next month if it's not in between the pay period,

 

[Luigi802]

I think I figured it out, using formula =IF(TODAY()>$B$12,DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY([@[Due Day]])),DATE(YEAR(TODAY()),MONTH(TODAY()),DAY([@[Due Day]])))

Where B12 is 1/29/16 and "[@[Due Day]]" is another column where I put the day of the month it's due on, i.e. if it's due on the 1st of each month then [@[Due Day]] would plainly be 1. I believe I had this formula before but I changed it cause I think I came across a scenario where it didn't work. If you could think of any reason why this wouldn't work please let me know!

 

[Luigi802]

Nope this didn't work either lol, just realized it now