Yes, Excel can differentiate between actual/360 and 30/360 amortization when creating an amortization schedule from scratch. Here's how:

1. Open a new Excel spreadsheet and create a table with the following columns: Payment Date, Payment Amount, Interest, Principal, and Balance.
2. In the Payment Date column, enter the first payment date.
3. In the Payment Amount column, enter the total payment amount for each period.
4. In the Balance column, enter the initial loan amount.
5. In the Interest column, enter the formula to calculate the interest for each period. For actual/360, the formula is:
   Code:

   (Balance * Rate * Days)/360

   . For 30/360, the formula is:
   Code:

   (Balance * Rate * Days)/360

   , where Days is calculated as follows: if the payment date falls on the last day of the month, use 30; if the payment date falls on the 31st day of the month, use 30; otherwise, use the actual number of days in the month.
6. In the Principal column, enter the formula to calculate the principal for each period. The formula is: Payment Amount - Interest.
7. In the Balance column, enter the formula to calculate the remaining balance for each period. The formula is: Balance - Principal.
8. Copy the formulas down to the rest of the rows in the table.
9. Format the table as desired.

By following these steps, you can create an amortization schedule in Excel that differentiates between actual/360 and 30/360 amortization.