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 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 14, 2013 at 12:18 AM
venkat1926 Posts 1863 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..
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..
Related:
- Help with a Formula 'Isblank refer to another cell"
- Refer to the graphic what type of cabling is shown - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Excel grade formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 14, 2013 at 12:18 AM
Jul 14, 2013 at 12:18 AM
the headings are ok
give two or three rows of data includilg where date is blank.
give two or three rows of data includilg where date is blank.