Forum Discussion
DatedIf Not Working
I'm trying to calculate the shelf life remaining on an item using the manufactured date & the expiration date. Using the DatedIf function I am attempting to formulate the following: =datedif(mfg_date...
=([end_date]-[start_date])/365.25 (or 30.4375, etc.)
works well enough for most purposes