Advertisements
Advertisements
प्रश्न
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.
कृति
Advertisements
उत्तर
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
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
