Calcluted Formula to get the last digit and the 2nd to the last digit of a number in a Column

%3CLINGO-SUB%20id%3D%22lingo-sub-895391%22%20slang%3D%22en-US%22%3ECalcluted%20Formula%20to%20get%20the%20last%20digit%20and%20the%202nd%20to%20the%20last%20digit%20of%20a%20number%20in%20a%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895391%22%20slang%3D%22en-US%22%3E%3CP%3EExample%3A%3CBR%20%2F%3EStudent%20Number%3A%202019-6703%3C%2FP%3E%3CP%3EThe%20last%20digit%20will%20be%20the%20month.%201%20stands%20for%20January%2C%202%20for%20February%2C%203%20for%20March%2C%20and%20so%20on.%3C%2FP%3E%3CDIV%20class%3D%22text_exposed_show%22%3E%3CP%3ESo%2C%203%20is%20for%20the%20month%20of%20March%3C%2FP%3E%3CP%3EFor%20the%202nd%20to%20the%20last%20digit%20number.%3C%2FP%3E%3CP%3ENumbers%201%2C%202%2C%20and%203%20a%20student%20should%20be%20enrolled%20within%20the%20working%20days%20from%20the%201st%20to%207th%20of%20the%20month%3B%3C%2FP%3E%3CP%3E4%2C%205%2C%20and%206%20of%20the%202nd%20to%20the%20last%20digit%20Will%20be%20on%20the%208th%20to%20the%2014th%20of%20the%20month.%3C%2FP%3E%3CP%3E7%20and%208%20on%20the%2015th%20to%20the%2021st%20of%20the%20month%3CBR%20%2F%3Ethen%3CBR%20%2F%3E9%20and%200%20on%20the%2022nd%20to%20the%20last%20day%20of%20the%20month.%3C%2FP%3E%3CP%3EBased%20in%20the%20scenario%20above.%3CBR%20%2F%3ECan%20you%20help%20me%20please%20formulate%20a%20calculated%20formula%20to%20a%20column%20as%20an%20end%20date%20of%20enrollment%20in%20a%20year%3F%3C%2FP%3E%3CP%3EExample%20would%20be.%3CBR%20%2F%3EStudent%20Number%20%3A%202019-6703%3CBR%20%2F%3EWe%20get%203%20(March)%20and%200%20(22nd%20to%20the%20last%20day%20of%20the%20month.)%3C%2FP%3E%3CP%3ESo%2C%20the%20student%20can%20only%20enroll%20on%20March%2022%20up%20to%2031%20the%20following%20year.%20Beyond%20that%20it%20is%20a%20penalty%20anymore.%3C%2FP%3E%3CP%3EI%20appreciate%20your%20help%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Example:
Student Number: 2019-6703

The last digit will be the month. 1 stands for January, 2 for February, 3 for March, and so on.

So, 3 is for the month of March

For the 2nd to the last digit number.

Numbers 1, 2, and 3 a student should be enrolled within the working days from the 1st to 7th of the month;

4, 5, and 6 of the 2nd to the last digit Will be on the 8th to the 14th of the month.

7 and 8 on the 15th to the 21st of the month
then
9 and 0 on the 22nd to the last day of the month.

Based in the scenario above.
Can you help me please formulate a calculated formula to a column as an end date of enrollment in a year?

Example would be.
Student Number : 2019-6703
We get 3 (March) and 0 (22nd to the last day of the month.)

So, the student can only enroll on March 22 up to 31 the following year. Beyond that it is a penalty anymore.

I appreciate your help

0 Replies