jtbrooklyn
New Member
- Joined
- May 9, 2013
- Messages
- 6
Hi all,
I am trying to create a headcount file for forecasting in excel. I have a Date of Hire (DOH) and date of termination (DOT). The problem I have is with my "if" formula. Here is what I am trying to do:
If(DOH is < = to (date), DOT = "", DOT > (date), then (1) or "" ). The problem I have is with the DOT being blank and DOT being greater then (date) one is always true? Unless I have a DOT the cell is blank. So even if the termination date is in another month it will always come up blank?
I am trying to create a headcount file for forecasting in excel. I have a Date of Hire (DOH) and date of termination (DOT). The problem I have is with my "if" formula. Here is what I am trying to do:
If(DOH is < = to (date), DOT = "", DOT > (date), then (1) or "" ). The problem I have is with the DOT being blank and DOT being greater then (date) one is always true? Unless I have a DOT the cell is blank. So even if the termination date is in another month it will always come up blank?