Help with a Formula 'Isblank refer to another cell"

Closed
lilylana1 Posts 1 Registration date Thursday July 11, 2013 Status Member Last seen July 11, 2013 - Jul 11, 2013 at 03:22 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 14, 2013 at 12:18 AM
I need a formula that will give me number of days between two columns Which contain dates, if one or the other has no date populated it would then refer to another cell which also should contains dates. If the difference is a negative number, should have text saying "dates out of sequence". I hope I am making sense.
There are actually 4 columns:
lets say A,B,C,D; the column titles are 095 Actual Date (A), 095 Forecast Date(B), 126 Actual Date(C) and 126 Forecast Date(D).
So its the difference between 095 & 126 columns.
The actual date is the 1st query and if there are no dates populated then should got to the Forecast date column.
Not sure if this makes sense to anyone! Please help..

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 14, 2013 at 12:18 AM
the headings are ok
give two or three rows of data includilg where date is blank.
0