ex.date of product Follow

0
Avatar
Efi Cohen

Hello,

I am using excel database for my products now about the expiry date. For example, if I am making an hamburger , the ex.date will be 2 month from the day of production unless the meat I am grinding has a shorter ex.date like a month from the day of production, how can I do it automatic to choose the shorter time between the two dates? Like in excel : =if( ex.date of the meat before grinding <2 month, ex.date of the meat before grinding, ex.date 2 month from the hamburger production date)

I hope you understand me

Thank you!!!
Efi cohen

Please sign in to leave a comment.