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.

Today is 1/24/16
Pay period	1/22/16	To	1/29/16
Bill	Amount	Due Date
Bill 1	$650.00	2/1/16
Bill 2	$200.00	2/5/16
Bill 3	$65.00	2/10/16
Bill 4	$50.00	2/21/16
Bill 5	$300.00	1/22/16
Bill 6	$25.00	1/23/16
Bill 7	$85.00	1/25/16
Bill 8	$40.00	1/28/16

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

 

[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