User Profile
MatsKleemans415
Copper Contributor
Joined Mar 12, 2022
User Widgets
Recent Discussions
Function unknown
Hi guys, I have a slightly complicated question, I’ll tell you straight away. In week 1 I have to estimate when my product is ready (kilos) to harvest. When I fill in 14 days in week 1 it means that I will harvest my product in week 3. However, when I fill in that my product is ready in 21 days I want to have those 10 kilos in week 4. I don’t need to know the precise number of the week a rounding is already fine. What is a good formula to use in the cells under predicted kilos(B1, downwards)? I was thinking of some if formulas but they don’t seem to work.Which function should I use?
Hi guys, I have a question, I have some really big data sets and I want to find some dates. However I don't know which function I should use I tried the IF function many times to find the harvest date from the code in Colum D, my formula was then =If(C:C;B:B;D2). This didn't result in the factor in the date that I want to get out. Any of you guys know how I can get the date from such data set? (this is just an example I have to do this from thousands of numbers). Thank you for helping me!
