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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Number of days from one date to another
Your example just states the number of days, and this can be obtained
by subtracting one date from the other and formatting as number with zero decimal places. You might also look into using DATEDIF if you want to express the result as x months y days. Hope this helps. Pete |
Reply |
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 |