How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Ryan-CTech Your Own Question

Ryan-CTech
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 524
Experience:  Expert VBA Programmer.
18042535
Type Your Microsoft Office Question Here...
Ryan-CTech is online now
A new question is answered every 9 seconds

Hello, I need help with an Excel spreadsheet. I need to

This answer was rated:

Hello, I need help with an Excel spreadsheet.

I need to create a sheet for the following scenario. I have a house cleaner that charges $20 an hour. I paid her $700 in advance. I want to make a chart where I can enter the amount of hours she was here on a certain date and have it show me how many hours she still owes, how many hours completed, how much money still has to be paid off etc.

How can I do this?
Thank you!

yegarboy :

Welcome To Just Answer!

yegarboy :

See if this will work for you :)

yegarboy :

Please let me know

Customer:

Thank you for this. It seems like it is just what I need. How can I add a column to give me dates every other wednesday?

yegarboy :

You want it set up for every 2nd Wednesday?

yegarboy :

In the Column type in the first 2 Dates like 5/10/2013 and 5/17/2013. Then Highlight the 2 cells. There will be a black + sign at the lower right of the cell. Click it and drag it down :)

yegarboy :

It will create a list of dates every 2 weeks

yegarboy :

The second date should have been the 24th...sorry about that

yegarboy :

Just as an Example anyways

yegarboy :

Here ya go :)

Ryan-CTech and other Microsoft Office Specialists are ready to help you