Hi,
I have a large SS which tracks all my deliveries, I want to put a formula in column C (Invoice Date) so that it auto-populates using the date inputted in column AK (POD date)
For ease, I would usually just put =AK2 into Cell C2, but if cell AK2 is blank I do not want cell C2 to have a date in there
How do I do this?
I have a large SS which tracks all my deliveries, I want to put a formula in column C (Invoice Date) so that it auto-populates using the date inputted in column AK (POD date)
For ease, I would usually just put =AK2 into Cell C2, but if cell AK2 is blank I do not want cell C2 to have a date in there
How do I do this?