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