Formula for providing value if value is shown in other cell

Hi guys,

Need your help with this one.

I need a formula where a value will be provided based on the value of another cell

A1 A2

B1 B2


Say A1 is empty but A2 contains date 01 Aug
If this is correct I want (with 1 formula) to have B1 as 0 and B2 as 17

However the trick is that we cannot assume that there is anything in either cells. I have a date formula that will give me dates in different places depending on week/month so the formula needs to simply see that there is a date in there.

Basically = if value is shown, give me 17, if no value is shown, give me 0.

Hope you guys can help me on this

Thanks guys,

I have to admit that this was a bit embarassing as its such a simple thing and I've looked at this formula earlier today in another report...