Hello Forum,
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.
Problem:
• 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!
Cheers,
Atrios
Bookmarks