Question

In: Economics

In Dominica, December 25 is Christmas. Given a year that a user enters, have your spreadsheet...

In Dominica, December 25 is Christmas. Given a year that a user enters, have your spreadsheet determine the date of Christmas. For example, if the user enters2030 as the year, your spreadsheet should display the date of Christmas is format 2030: Wd-Dec25. The formula should not display data is entered.

Solutions

Expert Solution

I have assumed that year will be entered in Cell A1 and result is required in Cell B1.

We can get the result by using the below mentioned formula in Cell B1.

=IF(A1="","",A1&": "&TEXT(DATE(A1,12,25),"ddd")&" - "&TEXT(DATE(A1,12,25),"mmm dd"))

Below is the screenshot of the formula in excel -

Below is the result as desired -


Related Solutions

Assume any rate. A user of your spreadsheet will need to input the following. Age (an...
Assume any rate. A user of your spreadsheet will need to input the following. Age (an integer) Gender (‘M’ or ‘F’) Desired superannuation withdrawal amount (in dollars) Desired annual income for ages 65 to 85, inclusive (males), or 65 to 87, inclusive (females). Assume this annual amount is paid on each birthday, starting at age 65, and ending at 85 for males and 87 for females. This stream of annual payments is what we refer to below as the user’s...
: : You and your family at organising Christmas lunch at your house this year. You...
: : You and your family at organising Christmas lunch at your house this year. You have a large family and expect 20 people to attend. Four people who will attend have dietary requirements, of these two people are vegans, one is gluten free, and one is both gluten and dairy free. Your mum loves to cook, you love to decorate, your dad loves to clean, your brother and sister love planning the menu. (1) Imagine that this is a...
Tine is Gabon is 8 hours ahead of Vancouver. Given any local date a user enters...
Tine is Gabon is 8 hours ahead of Vancouver. Given any local date a user enters in one cell, and local time in another cell, have your spreadsheet determine the date/time in Gabon in the format below. For example, if the user enters 11/1/20 in once cell, 6 PM in another cell, the formula result should display November 2, 2020 2:00 AM. The formula should not display data is no date and/or time is entered.
You are writing a billing program that adds up the items a user enters. Your program...
You are writing a billing program that adds up the items a user enters. Your program should use a loop and prompt the user for the item number for each item in inventory to add to the bill. (You can ask the user for the number of items you will enter and use a counter controlled loop or a sentinel controlled loop that has a stop number. Either way is fine.) Here is the table of items in inventory: Item...
When the user enters 4 at the menu prompt, your program will access all objects in...
When the user enters 4 at the menu prompt, your program will access all objects in the array to calculate and display only the largest number of coin denomination, and the total number of coins for the largest denomination. If there are more than one coin denominations having equal amount, you will need to list down all of them. After processing the output for menu option 4, the menu is re-displayed. Menu option 4 should return as follows. The largest...
I have 3 tables, but I need that when the user logs in and enters his...
I have 3 tables, but I need that when the user logs in and enters his login and password, it shows me only the information of that client. But it is showing me the information of all the clients. Bank(mid,code,cid,sid,type,amount,mydate,note) from CPS300 This is the table where I want the information of a client to be seen Customers(id,name,login,password) from CPS200 Sources(id,name) from CPS200 --------------------------------------------------------------------------------------------------------------------------------- for now I have two queries, but I must correct the one for client authentication because...
You are now 25 years old, and have just started working. Your salary for this year...
You are now 25 years old, and have just started working. Your salary for this year (i.e., the next 12 months) is $60,000 a year (payable at the end of the year). You expect your salary to increase at the (nominal) rate of 3% per year. You want to retire on your 60 birthday (i.e., 35 years from now). During retirement, you will be happy if you can have $75,000 per year. You expect to live until you are 90...
JAVA Take in a user input. if user input is "Leap Year" your program should run...
JAVA Take in a user input. if user input is "Leap Year" your program should run exercise 1 if user input is "word count" your program should run exercise 2 Both exercises should run in separate methods Exercise 1: write a java method to check whether a year(integer) entered by the user is a leap year or not. Exercise 2: Write a java method to count all words in a string.
Windsor Corporation enters into a 6-year lease of equipment on December 31, 2019, which requires 6...
Windsor Corporation enters into a 6-year lease of equipment on December 31, 2019, which requires 6 annual payments of $37,900 each, beginning December 31, 2019. In addition, Windsor guarantees the lessor a residual value of $18,800 at the end of the lease. However, Windsor believes it is probable that the expected residual value at the end of the lease term will be $8,800. The equipment has a useful life of 6 years. Assume that for Lost Ark Company, the lessor,...
Kingbird Corporation enters into a 6-year lease of equipment on December 31, 2019, which requires 6...
Kingbird Corporation enters into a 6-year lease of equipment on December 31, 2019, which requires 6 annual payments of $37,400 each, beginning December 31, 2019. In addition, Kingbird guarantees the lessor a residual value of $22,000 at the end of the lease. However, Kingbird believes it is probable that the expected residual value at the end of the lease term will be $12,000. The equipment has a useful life of 6 years. Assume that for Lost Ark Company, the lessor,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT