Excel Formula Help

[JungleJme]

Hi, i'm looking for someone to help me with the formula below. I can't see where i am going wrong. The formula is meant to:

 

Return the Number of working weeks between two dates (Start and End dates of contracts).

It also allows the user to enter a manual override in an adjacent cell (for use if they don't have firm dates but do have a contract length)

If the difference between the Start & End date is less than zero return the message "Check Dates"

 

All of the above works correctly, i have a problem with the final piece of logic:

 

If the user has entered an incorrect date (e.g. 30/02/09) that generates a #value error, to again return the message "Check Dates".

 

=IF(D9>0,D9,IF(H7="","",IF(C7="","",IF((H7-C7)/7<=0,"Check Dates",IFERROR(ROUNDUP((H7-C7)/7,0),"Check Dates")))))

 

D9 = Manual Override Cell to enter a number of weeks

H7 = End Date

C7 = Start Date

 

 

Using this formula still returns a "#value" error when an unrecognised date is entered in either C7 (start date) or H7 (end date).

 

As you can probably tell i am self-taught in Excel and I know it is long winded but hopefully there is some logic problem enthusiast out there who can help?

 

Thanks in advance for any help

 

Jme

[Guest Wolfeymole]

I'll have a play about with this Jungle and get back to you.