I have worked with my excel book for a while now, and I am close to a happy point but just can’t iron out a few last bugs. If you could please help, I would much appreciate it! I am using Excel 2010.
• I have attached my excel book for reference.
• Column G & H = Due to the formula I have in the two columns (=NOW()-C22) & (C22+21) [C22 contains a date], when I drag it down to the rest of the rows which don’t have data yet, I get this in column G=41563 and this in H=1/21/1900. I would like to not be able to see anything there until I add subsequent data. <-- please let me know if I need to further elaborate : )
If you see any other improvements you would suggest in my excel workbook (conditional formatting, etc), feel free to do so. Suggestions welcomed.
Thank you for looking at my situation!