ChrisFaye1
5 years agoQrew Cadet
Formula to display upcoming month (and year) referencing the day from a field
Hi,
Long story short I'm trying to create a formula that, when a month-to-month checkbox is checked, the field will reference another date field, keep the day, but adjust the month and year to be the upcoming month(year assumed).
Probably easier to show a few examples...
If ([Month to Month]=true,
Then reference [End Date], If [End Date] < Today, then assume the next month (year assumed) for the [Reported End Date].
Ex 1: End Date many months passed
Month to Month = true
Today's Date = 9/26/20
End Date = 5/05/20
Reported End Date: 10/5/20
Ex 2: End Date recently passed & turn of the year
Month to Month = true
Today's Date = 12/30/20
End Date = 12/10/20
Reported End Date: 1/10/21
Ex 3: End Date not yet passed
Month to Month = true
Today's Date = 9/26/20
End Date = 9/27/20
Reported End Date: 9/27/20
Thank You!
Chris
------------------------------
Chris
------------------------------
Long story short I'm trying to create a formula that, when a month-to-month checkbox is checked, the field will reference another date field, keep the day, but adjust the month and year to be the upcoming month(year assumed).
Probably easier to show a few examples...
If ([Month to Month]=true,
Then reference [End Date], If [End Date] < Today, then assume the next month (year assumed) for the [Reported End Date].
Ex 1: End Date many months passed
Month to Month = true
Today's Date = 9/26/20
End Date = 5/05/20
Reported End Date: 10/5/20
Ex 2: End Date recently passed & turn of the year
Month to Month = true
Today's Date = 12/30/20
End Date = 12/10/20
Reported End Date: 1/10/21
Ex 3: End Date not yet passed
Month to Month = true
Today's Date = 9/26/20
End Date = 9/27/20
Reported End Date: 9/27/20
Thank You!
Chris
------------------------------
Chris
------------------------------