Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I have a very simple function for every cell in column D, for example:
Example with values:
This works; however, not all the time. For cell D24 this returns a date 30-12, while B24 & C24 being empty.
if you see weird values like dates in your calculations, then its most likely due to formatting. to fix it do this (if you don't want decimals then click on More Formats and customize the visual as you wish):
Required, but never shown