Can't get this formula to work

[pboltonchina]

Hi Everyone, not been here for a long time but I need a bit of formula help please. I'm trying to look at 2 cells that have dates in them that calculate the number of days between those dates. If you just do a date formula it doesn't include both dates and returns 1 less than the actual count. However if the second cell is empty I don't want anything to show in the resultant cell until the second date is entered.
Here's what I am trying with

=IF((G2="",""),DAYS(G2,F2)+1

 

[RoryA]

You've got a bracket in the wrong place:

=IF(G2="","",DAYS(G2,F2)+1)

 

[pboltonchina]

This doesn't work. I notice you have 3 opening brackets and 2 closing brackets, does this make a difference

 

[Joe4]

I believe it should be:

=IF(G2="","",DAYS(G2,F2)+1)

 

[pboltonchina]

Just took took out one of the leading brackets and it's fine now.

Thank you

 

[RoryA]

Yes, sorry - I missed that you had the extra opening bracket in your original. I have removed it now.