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 -

Rahul Sunny answered 1 year ago

Next > < Previous

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.

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...

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.

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...

There are 2 user groups for your product. Group 1 are studentswith a demand given...

There are 2 user groups for your product. Group 1 are students with a demand given by 2000-50 P1 = Q1 and Group 2 are other customers with a demand given by 5500- 100 P2 = Q2. Total Cost = Fixed Cost + Variable Cost = $20,000 + $15Q Marginal Cost = ∂TC/∂Q = $15 for each. Note: Q= Q1 + Q2. Solve for P1 Q1 P2 Q2.Please solve for the equilibrium prices and quantities for both user groups P1...

Instructions: After you have completed the calculations on your spreadsheet that correlates to the questions below,...

Instructions: After you have completed the calculations on your spreadsheet that correlates to the questions below, you will copy and paste the portion of that spreadsheet into the Word document for each of the questions. Be sure to also provide a sentence that explains the solution. To save for her newborn son ’s college education, Lea Wilson will invest $1,000 at the end of each year for the next 20 years. The interest rate is 10%. What is the future...

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,...

Subjects