L Larry Jun 2, 2006 #1 I need a formula to count days between two dates (in cells) that would include leap years any help ?? Thanks Larry
I need a formula to count days between two dates (in cells) that would include leap years any help ?? Thanks Larry
G Guest Jun 2, 2006 #2 Hi Larry you could use the function DATADIFF as =DATADIF(initial_date,final_date,"type_of_differene") type of difference could be: "Y" - # of completed years between dates "M" - # of completed months bt dates "D" - # of completed days bt dates "MD" - Months and Years are ignorated "YD" - Days and Years are ignorated hope it helps regards from Brazil Marcelo "Larry" escreveu:
Hi Larry you could use the function DATADIFF as =DATADIF(initial_date,final_date,"type_of_differene") type of difference could be: "Y" - # of completed years between dates "M" - # of completed months bt dates "D" - # of completed days bt dates "MD" - Months and Years are ignorated "YD" - Days and Years are ignorated hope it helps regards from Brazil Marcelo "Larry" escreveu:
G Guest Jun 2, 2006 #3 sorry the correct function is DATEDIF.... I type it on Portuguese sorry "Marcelo" escreveu:
P Pete_UK Jun 2, 2006 #4 If you just want the answer in days, then you only need to subtract one from the other and format the cell as Number with zero decimal places, i.e.: =B1 - A1 if B1 contains the later date and A1 the earlier date. Hope this helps. Pete
If you just want the answer in days, then you only need to subtract one from the other and format the cell as Number with zero decimal places, i.e.: =B1 - A1 if B1 contains the later date and A1 the earlier date. Hope this helps. Pete
