SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 314 Weeks Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 30 Nov 2017 My Price 10.00

Nest the YEAR, MONTH, and DAY functions

I am in inf 314 and do not know how to do this part of the question on excel, can anyone help? In cell C11, enter a formula to reference the date stored in cell B7. Insert a nested function in cell C12 to calculate the date for the next payment. Nest the YEAR, MONTH, and DAY functions within the DATE function. Add 1 to the month result. Copy the function to the range C13:C34.   

Search Engine       Constants for Formulas  
Enter Unit # to see rent 101       Comparison Date 01/01/18  
Rental Price         No. of Years Since Remodel 10  
          Pet Deposit 2 bedroom newer $275  
          Pet Deposit other $200  
                 
Unit # Apartment Complex # Bed Rental Price Occupied Last Remodel Years Since Remodel Pet Deposit Recommendation
101 Rolling Meadows 1  $               950 Yes 04/01/04      
102 Rolling Meadows 1  $               950 Yes 03/01/13      
103 Rolling Meadows 2  $           1,100 No 11/15/05      
104 Rolling Meadows 2  $           1,100 Yes 10/01/15      
105 Rolling Meadows 3  $           1,500 No 10/01/15      
106 Rolling Meadows 3  $           1,500 Yes 06/15/04      
107 Rolling Meadows 2  $           1,100 No 11/01/15      
108 Rolling Meadows 2  $           1,100 Yes 08/15/09      
109 Rolling Meadows 3  $           1,500 No 08/15/09      
110 Rolling Meadows 3  $           1,500 Yes 10/04/06      
201 Rolling Meadows 1  $               875 Yes 04/13/16      
202 Rolling Meadows 1  $               875 Yes 03/01/13      
203 Rolling Meadows 2  $               995 Yes 04/01/04      
204 Rolling Meadows 2  $               995 No 04/01/10      
205 Rolling Meadows 3  $           1,050 Yes 08/15/11      
206 Rolling Meadows 3  $           1,050 No 07/01/05      
207 Rolling Meadows 2  $               995 Yes 08/01/15      
208 Rolling Meadows 2  $               995 Yes 08/01/15      
209 Rolling Meadows 3  $           1,050 No 08/01/15      
210 Rolling Meadows 3  $           1,050 Yes 11/04/06      
301 Lakeview Apartments 1  $               875 No 04/15/08      
302 Lakeview Apartments 1  $               875 No 05/01/15      
303 Lakeview Apartments 1  $               900 No 05/05/10      
304 Lakeview Apartments 1  $               900 Yes 05/05/10      
305 Lakeview Apartments 2  $           1,200 No 10/04/06      
306 Lakeview Apartments 2  $           1,200 Yes 06/15/18      
307 Lakeview Apartments 2  $           1,200 Yes 06/30/08      
308 Lakeview Apartments 2  $           1,200 No 09/30/07      
401 Mountaintop View 1  $               875 No 07/01/05      
402 Mountaintop View 2  $               950 No 08/01/15      
403 Mountaintop View 3  $           1,200 Yes 05/05/10      
404 Mountaintop View 1  $               875 No 10/04/06      
405 Mountaintop View 2  $               950 Yes 06/15/18      
406 Mountaintop View 3  $           1,200 No 04/01/04      
407 Mountaintop View 2  $               975 Yes 03/01/13      
408 Mountaintop View 2  $               975 Yes 11/15/05      
501 Sunset Valley 1  $               875 Yes 10/01/15      
502 Sunset Valley 1  $               875 No 08/01/15      
503 Sunset Valley 1  $               875 No 08/01/15      
504 Sunset Valley 1  $               875 Yes 07/02/03      
505 Sunset Valley 2  $           1,100 No 07/02/03      
506 Sunset Valley 2  $           1,100 Yes 10/10/10      
507 Sunset Valley 2  $           1,100 No 10/10/10      
601 Oak Tree Living 1  $           1,500 Yes 08/15/04      
602 Oak Tree Living 1  $           1,500 Yes 11/01/00      
603 Oak Tree Living 2  $           1,200 No 08/15/04      
604 Oak Tree Living 2  $           1,200 Yes 12/01/03      
605 Oak Tree Living 3  $           2,000 No 11/30/00      
606 Oak Tree Living 3  $           2,000 Yes 03/30/02      
607 Oak Tree Living 3  $           2,000 No 03/30/02      

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 30 Nov 2017 11:11 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)