If Then statement with dates

[mgallandt]

New member, first post, novice excel user:

Here is my if then - IF('Cost of Acq Funds (Invst Proft)'!B4>0,('Cost of Acq Funds (Invst Proft)'!B4-'Cost of Acq Funds (Invst Proft)'!B3),((now)-'Cost of Acq Funds (Invst Proft)'!B3))

where B3 = 3/7/2013
B4 = 4/26/2013 or blank<blank>

In english: I want to capture the difference in days between B3 and B4, or if I leave B4 blank, the day I'm looking at the spreadsheet's date.

I speculate my problem is with logical test (B4>0). How do I identify if B4 is left blank, to use NOW - B3?

This will give me a days in inventory # necessary for my investment proforma spreadsheet.

Thanks for any help.

Mark</blank>

 

[Firefly2012]

When you say NOW, do you mean the worksheet function NOW()? If you want number of days you probably want to use TODAY() instead.

Perhaps:

=IF('Cost of Acq Funds (Invst Proft)'!B4="",TODAY()-'Cost of Acq Funds (Invst Proft)'!B3,'Cost of Acq Funds (Invst Proft)'!B4-'Cost of Acq Funds (Invst Proft)'!B3)

 

[Comfy]

=IF(ISBLANK('Cost of Acq Funds (Invst Proft)'!B4),((now)-'Cost of Acq Funds (Invst Proft)'!B3),('Cost of Acq Funds (Invst Proft)'!B4-'Cost of Acq Funds (Invst Proft)'!B3))