Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
try something like this
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
Hi there, thanks for this. Are you able to tell me how the layout of the TODAY formula is ie. dd/mm/yyyy?
figured it out. thanks andrew.
Try something like this=TODAY()+((120/4)*7)
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.
No bother, I answered my own question.
Thank you for your help.
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?