Invetory in EXCEL 1

[JerrySpringer]

I keep my invetory in EXCEL. In cell E21 I have current stock, in F21 I have monthly usage, and in G21 I have the following formula =ROUND(E21/F21,0)-1 which tells me how many months of product I have. What I would like in H21 is a formula that tells me the month that I will re-order. Anyone have any ideas???

Thank you,

JS

 

[Wray69]

Hi Jerry,

You could use the following formula;
=DATE(YEAR(TODAY()), MONTH(TODAY())+G21, DAY(TODAY()))

then format the cell a customer format of MMMM and that will return the month name.

Hope this helps.

Cheers,

Wray

 

[JerrySpringer]

WOW, that was quick.... And it works perfectly, I have been trying to accomplish this for 2 weeks, wish I would of found this forum sooner. Thank you so much Wray.

JS