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
Formula To Convert Date to Camp
July 25, 2017 |
Labels:
AVN
This is for my personal usage.
The Formula:
A1 is the cell contains the camp
The Formula:
A1 is the cell contains the camp
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( ...
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