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 Today's Date to Current Camp
July 25, 2017 |
Labels:
AVN
This is for my personal usage.
The Formula:
Enter the formula in any cell. It will read today's date then will convert to camp format
The Formula:
Enter the formula in any cell. It will read today's date then will convert to camp format
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 Date to Camp
This is for my personal usage. The Formula: =IF(DAY(A1)>15,VALUE(YEAR(A1)&TEXT(MONTH(A1)*2 ...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment