Matt Young
New Member
- Joined
- Nov 2, 2018
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi. This is my first question sorry in advance.
So I hae two clumns C and D, D is my expiry date column and C is my start date column. I have formated D to turn orage or red depending on the time left. I also have the formual =EDATE(C3,6). The problem s that because nothng is acctually entered in colmn C yet then all of colmn D is displaying 01/06/1900 in red. Is there a way to make D stay blank until a date is entered in C?
So I hae two clumns C and D, D is my expiry date column and C is my start date column. I have formated D to turn orage or red depending on the time left. I also have the formual =EDATE(C3,6). The problem s that because nothng is acctually entered in colmn C yet then all of colmn D is displaying 01/06/1900 in red. Is there a way to make D stay blank until a date is entered in C?