FAQ

When using DAYS360, the most common questions fall into 3 areas: argument errors, unexpected results, and filling formulas across multiple cells; this section includes 3 frequent questions and a glossary.

FAQ

What should I do if DAYS360 returns #VALUE!?

1. Check whether the start date and end date cells contain valid date formats.
2. Check whether the arguments include text, extra spaces, or an incorrect separator.
3. Clean the source data if needed, then enter the formula again.

Why does the DAYS360 result look different from what I expected?

1. Confirm that a 360-day year is the right basis for your calculation.
2. Check whether start_date and end_date point to the correct cells.
3. If you used the method argument, confirm that it matches the date-counting rule required for your scenario.

How can I use DAYS360 in multiple cells at once?

1. Enter the DAYS360 formula in the first target cell.
2. Select that cell and move the pointer to the fill handle in the lower-right corner.
3. Drag the fill handle down or across to copy the formula to other cells.
4. Use $ in the formula if you need to lock specific rows or columns.

Glossary