Soldato
- Joined
- 1 Jul 2007
- Posts
- 5,392
Fairly new to excel and looking for help.
Creating a basics accounts type spreadsheet.
I have a column that is "invoice date" and the next is "due date" (=G.2+30)
I can copy the formula down the column, but annoyingly this fills in the due date column as 01/01/1901 if the invoice date is empty, for easy reading I would like it so no date is displayed in the due date till the invoice date is filled in. How do I acheive this?
Out of curiosity is the only way to copy a formula down an entire (like the above) is to drag and paste technique?
I will have follow up questions too...
Creating a basics accounts type spreadsheet.
I have a column that is "invoice date" and the next is "due date" (=G.2+30)
I can copy the formula down the column, but annoyingly this fills in the due date column as 01/01/1901 if the invoice date is empty, for easy reading I would like it so no date is displayed in the due date till the invoice date is filled in. How do I acheive this?
Out of curiosity is the only way to copy a formula down an entire (like the above) is to drag and paste technique?
I will have follow up questions too...