Philippine National Bank - Dispute Form

https://docs.google.com/spreadsheets/d/1CrOZeVsSyhY-uoQESIdTPqRK9sKKYiUf/edit?usp=drive_link&ouid=102592117366186877411&rtpof=true&sd=true

How to duplicate a row of Dates into 5 rows arranged according to date.

=DATE(2026,7,1) + INT((ROW(A2)-ROW($A$2))/5)

------------------------------------------------------------------------------------------

n Microsoft Excel

For this example, assume your first date starts on July 1, 2026. [1]

Using a Formula:

1. Click the first cell (e.g., A2) where you want your list to begin.
2. Enter the following formula, replacing DATE(2026,7,1) with your exact start date:
   =DATE(2026,7,1) + INT((ROW(A2)-ROW($A$2))/5)
3. Press Enter, then drag the formula down until you have filled the desired number of rows. [1, 2, 3]

Using the SEQUENCE Function (Excel 2021 or Microsoft 365):

1. Click the first cell (e.g., A2). [1]
2. Type this dynamic array formula:
   =SEQUENCE(20, 1, DATE(2026,7,1), 0.2)
   • Note: Setting the step to 0.2 (which is equal to \(\frac{1}{5}\) of a day) increments the date by exactly 1 day for every 5 rows. [1]
3. Select the column, go to the Home tab, click the Number Format dropdown, and select Short Date. [1]

---

In R Programming

You can use a combination of rep (replicate) and seq.Date to create this vector instantly. [1, 2]

1. Run this code snippet to generate a sequence of, for example, 30 sequential days, repeated 5 times each:
   my_dates <- rep(seq.Date(from = as.Date("2026-07-01"), to = as.Date("2026-07-30"), by = "day"), each = 5)
2. If you need it to be a clean data frame column, you can format it as a tibble:
   date_column <- tibble(Date = my_dates) [1, 2, 3, 5]

---

In Google Sheets

1. Enter your starting date in the first two cells (e.g., A1 and A2).
2. Highlight the first 10 cells in the column (since 5 per date will occupy rows 1-10).
3. Click and drag the blue fill handle in the bottom-right corner of the selection downwards.
4. Click the small Auto-fill options menu at the bottom of your drag and ensure it is set to Fill Series. [1, 2, 3, 4, 5]

How to Print without Gridlines

To print Google Sheets without gridlines, open your spreadsheet, go to File > Print, and open the Formatting menu on the right side of the print settings. Uncheck the "Show grid lines" option, review the preview, and click Next to proceed with printing. [1]