I have a formula "=days360(d3,d4)-d15" that keeps changing to a text format which in turn creates a #VALUE! in the cells referencing the formula. I've searched the internet, but have come up empty as far as a resolution - any ideas?
Date
Votes
1 comment
-
Jet Reports Historic Posts First question are your start and end cells formated as dates ?
The days360 formula (at least in 2007) requires 3 fields start, end, method and it returns the number of days based on a 360 day year ( So just how many 360 day years are there :| )
Since the result is numeric the value in your -cell would have to be a number as well or you will get the #Value error
So just out of curiousity what is it your trying to achieve ?
Please sign in to leave a comment.