Todo list excel

https://docs.google.com/spreadsheets/d/1r6-K0eHvRAoq5zHISW2DhSU3NU2p_tHw5mRlkjgT9nY/edit?usp=drivesdk

DATE AND AGE VALIDATION IN COBOL

USEFUL THINGS IN COBOL

*******************************************

SOME USEFUL  THINGS

*******************************************
COMPUTE DDN = FUNCTION NUMVAL (DD).
***************
NUMVAL CONVERTS CHARACTERS TO NUMBERS
***************

IF
DIVIDE CCYY BY 4 GIVING CCYY REMAINDER CCYY
DISPLAY 'LEAP YEAR'.
END-IF.
DISPLAY CCYY.

MOVE FUNCTION DATE-OF-INTEGER (DATEINTEGER) TO DATENUMBER.
DISPLAY DATENUMBER.
***********
1600 DEC 31 GREGORIAN
*****************
IDENTIFICATION DIVISION.
PROGRAM-ID. DATE.
DATA DIVISION.
WORKING-STORAGE SECTION.
01 DATENUMBER PIC 9(8).
01 DATEINTEGER PIC 9(8).
PROCEDURE DIVISION.
MOVE 20170914 TO DATENUMBER.
IF DATENUMBER IS NOT NUMERIC
              DISPLAY 'NOT NUMBER'
ELSE
              MOVE FUNCTION INTEGER-OF-DATE (DATENUMBER) TO DATEINTEGER.
    IF DATEINTEGER EQUAL ZERO
              DISPLAY 'DATE IS INVALID'
    ELSE
              COMPUTE DATENUMBER = FUNCTION NUMVAL (FUNCTION CURRENT-DATE(1:8)) - DATENUMBER
        IF DATENUMBER(1:4) < 20 OR > 60
              DISPLAY 'AGE IS LESSTHAN 20 OR GREATERTHAN 60'
END-IF.
STOP RUN.
*******************************