View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Blddrgn700 Blddrgn700 is offline
external usenet poster
 
Posts: 6
Default Do NOt Know Which Function to Use

Hi All:

I am working with a cash forecast model (same one as before) and I have a
probelm that I have not encountered before.

I have two separate dates on two separate columns and rows with a column of
dates for payroll. I am trying to create a formula that will use the two
initial dates as a control field and the actual payroll dates to drive the
results.

Column A Column B
R1 01/01/08 01/15/08
R2 01/07/08 01/23/08 etc....


R4 1/05/08 $$$$.$$
R5 1/20/08 $$$$.$$
R6 etc....
R7 etc...

I have tried an "IfThen" type logic but it errors out.

Thanks in advance for your help and advance.

Kurtis