Formula To Get Start and End Date from Camp

This is for my personal usage.

Formula for Start Date:

=DATE(VALUE(LEFT(A1,4)),ROUND(VALUE(RIGHT(A1,2))/2,0),IF(ISODD(VALUE(RIGHT(A1,2))),1,16))

Formula for End Date:

Next Camp start date - 1

Note:
A1 contains the camp

Formula To Convert Today's Date to Current Camp

This is for my personal usage.

The Formula:

=VALUE(YEAR(TODAY())&TEXT(IF(DAY(TODAY())<=15,MONTH(TODAY())*2-1,MONTH(TODAY())*2),"00"))

Note:
Enter the formula in any cell. It will read today's date then will convert to camp format

Formula To Convert Date to Camp

This is for my personal usage.

The Formula:

=IF(DAY(A1)>15,VALUE(YEAR(A1)&TEXT(MONTH(A1)*2,"00")),VALUE(YEAR(A1)&TEXT(MONTH(A1)*2-1,"00")))

Note:
A1 is the cell contains the camp