Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
proper syntax order
Hello all, I have three fields
"ReceivedDate" "Date" "Total Days" The first two are date fields, the second I want to either count the number of days between the dates or if no "Date" than "Total Days" would should "0". "Date" - "ReceivedDate" = "Total Days" 2/6/06 - 1/12/06 = 25 This works - if that's all I needed, however, "Date" - "ReceivedDate" = "TotalDays", If "Date" is blank, then "TotalDays" = 0 I can't get the right order to make this simple formula work. Please help. Thank you. -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Maintaining a default worksheet order | Excel Discussion (Misc queries) | |||
Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions | |||
Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) |