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 - 1Note:
A1 contains the camp
Formula To Get Start and End Date from Camp
July 25, 2017 |
Labels:
AVN
This is for my personal usage.
Formula for Start Date:
A1 contains the camp
Formula for Start Date:
A1 contains the camp
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 ...
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, ...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment