formula for unique date range - 15th - 14th of each month as opposed to full calendar months

[doug firr]

Hello

I have two columns: date (yyyy/mm/dd) and data associated with each date.

I'd like to group by month that ties in with our reporting period, which is not calendar months but mid months - 15th - 14th.

Is there a way to easily tell either my pivot table to do this or add a new column with formula next to date for each row to allow my pivot table to do this?

 

[bellman101]

the formula you would need would be:

=If(Day(daterange here)>14,if(month(daterange here)=12,1,month(daterange here)+1),month(daterange here))

Just replace "daterange here" with the cell reference.

 

[doug firr]

Thank you!