predict the end date of a material...

[FuNeS13]

I was approach yesterday with a comment of someone who "Saw" someone write a function in excel which told here when was going to be the last day of material availability... Say that you have material ABC and you are currently holding 100 piezas... with a daily consumption of 10 pcs per day, with this function she would get that may 8th as the ast day she would run out of inventory... Does this function exists? Or do you believe it was a user creating a vba function to get this data?

 

[kweaver]

=TODAY()+100/10

 

[FuNeS13]

=TODAY()+100/10

I guess that's it, because I tried finding a function that would get me this but I just couldn't I guess she wasn't sure what she saw...