Forum Discussion
Solved
Empty Date Cell shows as 1/0/1900, but want it blank
Hi there! I'm a novice, so bear with me. Numbered items below in green are working just fine, items in red are what I'm having issues with: L7 has formula =N7-M7 However, I want for cells i...
HansVogelaar Good morning.
I have a similar problem, but I am no computer expert and a bit of a thickie to be honest!
A1 is a date of entry, K1 is a 7 day follow up (formula used is =A1+7) M1 is 14 day follow up (formula used is =K1+7) All this works, but a default date shows in all K and M columns and when I clear contents, it erases the formula and I hate having dates showing on empty rows!
I am a dinosaur and do not understand Excel terminology.
Are you able to help an old man drowning in tech speak please?
Rich