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
Stop searching. Start learning and developing your excel skills.
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
Other Excel Tutorials:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment