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 The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1871
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

Hi there, I would like to know how to use excel to calculate

This answer was rated:

Hi there, I would like to know how to use excel to calculate stock end dates. For example. If I have 120 units, and I go through an average of 4 units per week (assuming stock was drawn down on a Monday), what formula would I use to get the date my stock would run out.

Many thanks in advance.
Richard.

The-PC-Guy :

Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

The-PC-Guy :

try something like this

The-PC-Guy :

=TODAY()+((120/4)*7)

The-PC-Guy :

based on your example that would give you the end date

The-PC-Guy :

based on today's date

The-PC-Guy :

you can change the numbers as you see fit

Customer:

Hi there, thanks for this. Are you able to tell me how the layout of the TODAY formula is ie. dd/mm/yyyy?

Customer:

figured it out. thanks andrew.

Try something like this

=TODAY()+((120/4)*7)

based on your example that would give you the end date

based on today's date

you can change the numbers as you see fit

 

based on your example that gives me a date of 3/25/2014. Let me know if you will be needing anything else

 

if you need any modifications to the formula, or have questions let me know.

The-PC-Guy and 2 other Microsoft Office Specialists are ready to help you
Sorry, I didn't see your last response.

Can you please reload the web page, and try again.

Thanks.
Customer: replied 3 years ago.

No bother, I answered my own question.


 


Thank you for your help.

Thats good to hear!

Please rate me Good or Excelent Service so I can get reimbursed for my time

Thankyou.
Customer: replied 3 years ago.

Hi Andrew, if I could bother you for one more question. I was wondering what formula I would use to work out a projected total number of stock units usage from todays date up till a predetermined end date.


 


eg. If a customer used 1 unit per week from the current week, up until say the 12/30/2013, what formula would I use to figure out the total number of units used or allocated between now and then?

so you would want to know how many units was used between the 2 dates?

Related Microsoft Office Questions