| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
showing negative numbers
I am using this formula to show the amout of days between two dates. =datedif(today(),a2,"d") this works well as long as the date in cell A2 is in the future. If todays date is after the the date in cell A2 It wont show the days as a negative number as I want it to. insted the cell shows this. #NUM! can anyone help with this. Thanks -- dzeitler ------------------------------------------------------------------------ dzeitler's Profile: http://www.excelforum.com/member.php...o&userid=24019 View this thread: http://www.excelforum.com/showthread...hreadid=377418 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| How do I show negative numbers on a stacked graph | Charts and Charting in Excel | |||
| Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) | |||
| can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
Threaded Mode
