Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
count days
I need a formula to count days between two dates
(in cells) that would include leap years any help ?? Thanks Larry |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
count days
Hi Larry you could use the function DATADIFF as
=DATADIF(initial_date,final_date,"type_of_differen e") 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: I need a formula to count days between two dates (in cells) that would include leap years any help ?? Thanks Larry |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
count days
sorry the correct function is DATEDIF....
I type it on Portuguese sorry "Marcelo" escreveu: Hi Larry you could use the function DATADIFF as =DATADIF(initial_date,final_date,"type_of_differen e") 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: I need a formula to count days between two dates (in cells) that would include leap years any help ?? Thanks Larry |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
count days
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 Marcelo wrote: sorry the correct function is DATEDIF.... I type it on Portuguese sorry "Marcelo" escreveu: Hi Larry you could use the function DATADIFF as =DATADIF(initial_date,final_date,"type_of_differen e") 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: I need a formula to count days between two dates (in cells) that would include leap years any help ?? Thanks Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar Days and Option Buttons | Excel Discussion (Misc queries) | |||
Formula to count number of days in range which are less than today | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
how do I make a function to count days? | Excel Worksheet Functions |