Posts by Tom.Jones

Re: Get previous month from Date

Try this:

="For the month of " &TEXT(EOMONTH(E3,-2),"mmm-yy") result is For the month of dec-14

BUT previous month from Date of Feb-15 is Jan-15

Re: Stock calculation

Ingo_Ingo,

Thanks for the reply, but at work I can not use VBA code and I need a solution with formula if possible. Thank you.
Hope someone will help me.

Re: Stock calculation

Nobody can help?

Hi,

Please help me in calculating the inventory of products. Attached file contains 31 sheets (1 to 31) each sheet represents one days out of a given month. In sheet "Centr.'' I need to calculate the stocks of certain products meet every day, which is not fixed.
See the attached file to see exactly what they want.

I do not know why I can not upload the file. Has 227 K.