Advertisements
Advertisements
Question
Use a Days 360 function to work out how many days are left before your next birthday. Instead of typing out the current date in, say, cell A2, you can use this built-in function:
=Now ( )
The Now function doesn’t need anything between the round brackets. Once you have today’s date, you can enter your birthday in, say, cell B2.
Activity
Advertisements
Solution
Spreadsheet Layout Example
| Cell Address | Column Description | Value/Formula Entered | Example Date Result |
| A2 | Current Date | =NOW() | 15-08-2026 |
| B2 | Next Birthday | 25-12-2026 | 25-12-2026 |
| C2 | Days Remaining | =Days 360(A2, B2) | 130 |
The DAYS360 function treats every month as exactly 30 days. Based on our random dates above, Excel breaks down the 130 days.
August remaining days: 30 days − 15 days
= 15 days
Full months (September, October, November): 3 months × 30 days = 90 days
December birthday days: 25 days
= 15 + 90 + 25
= 130 days
shaalaa.com
Is there an error in this question or solution?
