Hello everyone....
I have a question when working with dates.
I created a spreadsheet that uses two date, say the sign-up date plus 90 days. Easy formula, that cell with date+90. My question is when I copy the formula down with the auto-fill handle (no sign up date in adjacent column), I get 03/10/1900 over and over again... of which I understand why this is happening.
My question- is there a way to cover up, via a formula, or conditional formatting to NOT show the 03/10/1900 values over an over. My goal is just to populate the sign up date and not have to drag down (auto-fill) the associated formula every time.
Thoughts?
I have a question when working with dates.
I created a spreadsheet that uses two date, say the sign-up date plus 90 days. Easy formula, that cell with date+90. My question is when I copy the formula down with the auto-fill handle (no sign up date in adjacent column), I get 03/10/1900 over and over again... of which I understand why this is happening.
My question- is there a way to cover up, via a formula, or conditional formatting to NOT show the 03/10/1900 values over an over. My goal is just to populate the sign up date and not have to drag down (auto-fill) the associated formula every time.
Thoughts?
