| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date Formula
Can anyone help? I need to create a formula that will give me the amount of days between two dates i.e., 01/31/05 - 01/01/05 = 30 days. I know it's 30 because I used a sample that would be easy but I'm working on a large amount that might be 60, 40 or so. I used the HELP on Excel but it gives me i.e. 01/31/05 - 01/01/05 = 01/30/1900. What am I doing wrong??? Please email me at REALLY NEED HELP...! -- leanete ------------------------------------------------------------------------ leanete's Profile: http://www.excelforum.com/member.php...o&userid=13303 View this thread: http://www.excelforum.com/showthread...hreadid=396168 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| addition to my date formula...required | Excel Worksheet Functions | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| Formula with date constraints | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Threaded Mode
