ExcelFanatic
Board Regular
- Joined
- May 22, 2009
- Messages
- 83
In my spreadsheet columns L through O contain dates:
L - Planned Start Date
M - Actual Start Date
N - Planned End Date
O - Actual End Date
In column Q I am looking for the number of days between the start and end date using the following formula:
If the column M is blank, I want to use the date in column L,
If column O is blank, I want to use the date in column N
=IF(M7190="",L7190,M7191)-IF(O7190="",N7190,O7190)
My formula is not working.
L - Planned Start Date
M - Actual Start Date
N - Planned End Date
O - Actual End Date
In column Q I am looking for the number of days between the start and end date using the following formula:
If the column M is blank, I want to use the date in column L,
If column O is blank, I want to use the date in column N
=IF(M7190="",L7190,M7191)-IF(O7190="",N7190,O7190)
My formula is not working.