Thread: Why do I get a #value error when doing the 360days formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Why do I get a #value error when doing the 360days formula?
Recheck your data in C1:C2 that these are real dates recognized by Excel
Probably C1 &/or C2 contains text
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"trainer07" wrote:
I am trying to find the number of days between two dates, but when I create
the formula, I receive a #value error message in the cell. Both cells that
have the dates in them are formatted as date. Here is how I wrote the
formula:

=days360(C1,C2)

Any assistance would be appreciated.
Reply With QuoteReply With Quote