I have one column that has either nothing or a date, I want to calculate the days that past between the date just being entered and the previous date. My problem is, the gaps between dates always vary and this sheet will have hundreds or rows. any sugestions will help, i don't think writing an if statment to cover a span of 100 rows is practical or even if you can
Is there a date in the first row of the column?
If so, then I would cheat - assuming you cannot just populate the blank fields with the preceding date, you could make a new hidden column that did. Lets assume A1 is the first date column. then B1, the hidden column, can contain
B2 can contain
So B2 contains A2 unless A2 is empty, then it contains B1. Paste this down the entire column and it will ensure there are no blanks.
Column C can then contain the difference calculation. It would contain the following pasted the entire length:
Ie, show the number of days difference between the two dates, provided they are different, otherwise show a blank.