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 |
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 |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com