Important Notice: This article applies to the New ParishSOFT Platform. If your diocese hasn’t migrated yet, explore our knowledge base for relevant resources.
Export CSV File:
In the Families module tab, navigate to Family Directory > Member List:
If necessary, filter the list down to a specific group of members.
Click on the grid icon to select the columns you would like to appear on your report.
Click the export to CSV icon:
Open the file in Excel, and use the simple formulas shown below to extract the day, month, or year from the birthday field.
Extract day, month, or year from birth date field in CSV file
The following instructions will show you how to extract all three of these fields (day, month, year) from the date field. Choose the one by which you want to sort your report (or you may add them all).
- Start by adding one column header for each date segment you would like to extract: Day, Month, Year. In the example below, where the birth date is in column A, we added the following column headers:
- Day to column C
- Month to column D
- Year to column E
- Using the example below as your guide add the formula to the first row (in our case row 2) which contains the birth date which in this case is in column A: (Please note, you denote the column containing the birth date on your spreadsheet)
- =DAY(A2), press Enter
- =MONTH(A2), press Enter
- =YEAR(A2), press Enter
- You may then drag your formula down to the bottom row containing a birth date.
- As you can see, the formula extracts the correlated section of the date and displays it in the cell.
- Finally, select all of the data in the report then use the custom sort to sort by whichever field you would like to have your records ordered.
Updated