Forum Discussion
IF FORMULA - Help Needed please
SGeorgie One last suggestion... make sure your Calculation Options are set to Automatic, or press F9 on your keyboard to recalculate the entire workbook. The most likely reason you're getting incorrect results is that your Calculation Options are set to Manual.
ive tried F9
I have made sure all date columns ae Date and correct format - K/O/U is 2019-06-01
Column L, P and V though have =K+1-1 so they display as 01/06/2019
Does that make a difference? Any way I can send you my dummy file?
- djclementsNov 15, 2023Bronze Contributor
SGeorgie Please see the attached example file that's confirmed to be working on my system. Download it, if possible, then add or change dates in each column to create various scenarios and see if it's working for you. If not, then the problem most likely lies on your end with either a system setting or Excel setting. If it works correctly, though, and you're still not able to identify the reason why your file is not working, try to attach a dummy file in your next reply (go to the full editor, then find the area to "browse files to attach" below the editor).