Question

Using Excel, answer the following. The first quarter of the year is January–March; the second quarter,...

Using Excel, answer the following. The first quarter of the year is January–March; the second quarter, April–June; the third quarter, July–September; and the fourth quarter, October–December. Write a formula that returns (for any given date) the quarter of the year.

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Formula : =ROUNDUP(MONTH(CellContainingDate)/3,0)

Explanation:

The basic idea in finding the quarter of the year is to get the corresponding month as integer (which is always between 1 - 12) and divide it by 3 and finally rounding it up. So here we first extract the integer value of the month from the cell containing the date and divide it by 3. Then ROUNDUP function is used to round the result to the nearest whole number.

The output of the above formula will be just integers denoting the corresponding quarter (1,2,3..). If we want to print like "Quarter1", "Quarter2", ... etc then slight modification in the formula will do the trick:

="Quarter" & ROUNDUP(MONTH(CellContainingDate)/3,0)

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In the first quarter of the year, Real GDP was $400 billion; in the second quarter...
In the first quarter of the year, Real GDP was $400 billion; in the second quarter it was $398 billion; in the third quarter it was $399 billion; and in the fourth quarter it was $395 billion. Has there been a recession? Explain your answer.
A book claims that more hockey players are born in January through March than in October...
A book claims that more hockey players are born in January through March than in October through December. The following data show the number of players selected in a draft of new players for a hockey league according to their birth month. Is there evidence to suggest that hockey​ players' birthdates are not uniformly distributed throughout the​ year? Use the level of significance alpha equalsα=0.05. Birth Month Observed Count Expected Count ​January-March 59 45.5 ​April-June 59 45.5 ​July-September 29 45.5...
Finch Company began its operations on March 31 of the current year. Finch has the following...
Finch Company began its operations on March 31 of the current year. Finch has the following projected costs: April May June Manufacturing costs (1) $155,500 $192,600 $216,100 Insurance expense (2) 860 860 860 Depreciation expense 2,170 2,170 2,170 Property tax expense (3) (1) Of the manufacturing costs, three-fourths are paid for in the month they are incurred; one-fourth is paid in the following month. (2) Insurance expense is $860 a month; however, the insurance is paid four times yearly in...
Finch Company began its operations on March 31 of the current year. Finch has the following...
Finch Company began its operations on March 31 of the current year. Finch has the following projected costs: April May June Manufacturing costs* $159,000 $197,000 $200,000 Insurance expense** 1,100 1,100 1,100 Depreciation expense 2,020 2,020 2,020 Property tax expense*** 440 440 440 *Of the manufacturing costs, three-fourths are paid for in the month they are incurred; one-fourth is paid in the following month. **Insurance expense is $1,100 a month; however, the insurance is paid four times yearly in the first...
1. Prepare a monthly cash budget for the first quarter of the fiscal year beginning July...
1. Prepare a monthly cash budget for the first quarter of the fiscal year beginning July 1, assuming the following facts: a. Cash collections typically average 50% of charges. Cash is received, on average, 40% in the month of service, 30% in the next month, 15% in the second month after service, 5% each in the next two months and 5% is uncollectible. b.​Charges for February, March, April, May, and June were $300.000, $400,000, $400,000, $200,000 and $500,000, respectively. Charges...
A book claims that more hockey players are born in January through March than in October...
A book claims that more hockey players are born in January through March than in October through December. The following data show the number of players selected in a draft of new players for a hockey league according to their birth month. Is there evidence to suggest that hockey​ players' birthdates are not uniformly distributed throughout the​ year? Use the level of significance α=0.01. Hockey League Players' Birth Month Birth Month ​January-March ​April-June ​July-September ​October-December Frequency 61 56 25 32...
Incidents By Month For 2018 January 5,400 MEAN MEDIAN MODE February 4,930 5,181 5,216 5260 March...
Incidents By Month For 2018 January 5,400 MEAN MEDIAN MODE February 4,930 5,181 5,216 5260 March 5,330 April 5,042 May 5,143 June 5,172 July 5,260 August 5,260 September 5,339 October 5,283 November 4,909 December 5,109 Is it a standard distribution, why or why not?
Finch Company began its operations on March 31 of the current year. Finch has the following...
Finch Company began its operations on March 31 of the current year. Finch has the following projected costs: April May June Manufacturing costs (1) $155,900 $190,900 $214,600 Insurance expense (2) 1,060 1,060 1,060 Depreciation expense 1,910 1,910 1,910 Property tax expense (3) 460 460 460 (1) Of the manufacturing costs, three-fourths are paid for in the month they are incurred; one-fourth is paid in the following month. (2) Insurance expense is $1,060 a month; however, the insurance is paid four...
1- Dhofar Inc. has the following sales forecasts for next year: First Quarter                10,000 units...
1- Dhofar Inc. has the following sales forecasts for next year: First Quarter                10,000 units Second Quarter           6% increase over first quarter Third Quarter              4% decrease from second quarter Fourth Quarter            7% increase over first quarter What is Dhofar's estimated sales in units for next year? Select one: a. 42,225 units b. 41,485 units c. 41,476 units d. 41,900 units 2- The finished-goods inventory at the end of July was OMR 38,000. The beginning finished-goods inventory was OMR 52,000....
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these​...
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these​ data, estimate the average monthly return and the volatility for each stock. Month Cola Co. Gas Co. January -0.20​% 0.30​% February -7.20​% -3.90​% March 6.26​% -3.70​% April -7.10​% -4.90​% May 1.60​% -5.70​% June 4.90​% -4.60​% July 3.00​% 0.70​% August -2.70​% -6.40​% September 0.00​% -0.90​% October 10.50​% 10.20​% November 4.90​% -6.70​% December 4.20​% -1.50​% The average monthly return for Cola Co. is ? ​%. ​
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT