| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Number of days from one date to another
I need I formula to calculate the number of days from one date to another. Example: 01-May-06 to 05-June-06 = 36 days I've tried the 360 day function, but the problem being it calculates based on 360 days not the number of days in each month. Each month is either 28, 30,or 31 days in it. I need a formula that calculates on the month not the day. Please somebody help me with this!! -- Renz09 ------------------------------------------------------------------------ Renz09's Profile: http://www.excelforum.com/member.php...o&userid=34069 View this thread: http://www.excelforum.com/showthread...hreadid=538357 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Threaded Mode
