jiggaman84
New Member
- Joined
- Jan 22, 2010
- Messages
- 17
Hey,
I've got a real head scratcher and I hope someone out there can help me.
Here is the situation: I have 4 dates -- Budgeted Possession Date, Actual Possession Date, Budgeted Commencement Date, Actual Commencement Date.
Budgeted Possession always comes before Budgeted Commencement and Actual Possession always comes before Actual Commencement. It is possible that Actual Possession or Actual Commencement happens before, in between, or after Budgeted Possession and budgeted Commencement (and vice versa).
I need to show what happens every month for one year depending on when these dates fall. I've tried some nested If(And statements but I quickly become overwhelmed. Basically I need a formula that covers every scenario possible.
Can this be done?
Thanks in advance.
I've got a real head scratcher and I hope someone out there can help me.
Here is the situation: I have 4 dates -- Budgeted Possession Date, Actual Possession Date, Budgeted Commencement Date, Actual Commencement Date.
Budgeted Possession always comes before Budgeted Commencement and Actual Possession always comes before Actual Commencement. It is possible that Actual Possession or Actual Commencement happens before, in between, or after Budgeted Possession and budgeted Commencement (and vice versa).
I need to show what happens every month for one year depending on when these dates fall. I've tried some nested If(And statements but I quickly become overwhelmed. Basically I need a formula that covers every scenario possible.
Can this be done?
Thanks in advance.