Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating # of days
hi
I used =DATE (b10,c10,d10)-DATE(b9,c9,d9) what should I have done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating # of days
The formula should work as written. What do you get as a result? What are
the values you are working with? Be sure to format the formula cell for General, not Date. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "leslie" wrote in message ... hi I used =DATE (b10,c10,d10)-DATE(b9,c9,d9) what should I have done? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating # of days
On Sat, 23 Jun 2007 17:00:00 -0700, leslie
wrote: hi I used =DATE (b10,c10,d10)-DATE(b9,c9,d9) what should I have done? With so little information, it's hard to tell. Most likely, you should have had entries in B9:D10 that would be valid arguments for the DATE worksheet function. Post the contents of B9:D10 What did you get?? What did you expect?? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Days per month for calculating storage days | Excel Worksheet Functions | |||
Calculating Days Between Dates | New Users to Excel | |||
calculating days | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating days | Excel Worksheet Functions |