From: Working With Dates in Excel Working With Dates in on 24 May 2010 18:25 Hello: I use Excel to keep up with information like the number of days I was employed by a given employer. I included the first day of work on my worksheet for example as 1/1/2010 then I type the last day I worked there for example 12/31/2010. Now then with the first and last date displayed on my sheet for common reference purposes I want to determine the total days I was employed by this employer so I substract 12/31/2010 from 1/1/2010 but Excel returns the value 364 when I was employed 365 days. In this example I would not want to put 12/31/2009 as my first day of work or 1/1/2011as my last so Excel would return the correct number of days which is 365 when I didn't work there those days. Any info as how this should be done would be appreciated. I would hope it would not require some complexed process to get Excel to carry data like I am trying to. From: Victor Delta on 24 May 2010 18:43 "Working With Dates in Excel" wrote in message news:2288C511-075C-424B-B8DA-55EB59FC9873(a)microsoft.com...> Hello: > > I use Excel to keep up with information like the number of days I was > employed by a given employer. I included the first day of work on my > worksheet for example as 1/1/2010 then I type the last day I worked there > for > example 12/31/2010. Now then with the first and last date displayed on my > sheet for common reference purposes I want to determine the total days I > was > employed by this employer so I substract 12/31/2010 from 1/1/2010 but > Excel > returns the value 364 when I was employed 365 days. In this example I > would > not want to put 12/31/2009 as my first day of work or 1/1/2011as my last > so > Excel would return the correct number of days which is 365 when I didn't > work > there those days. Any info as how this should be done would be > appreciated. I > would hope it would not require some complexed process to get Excel to > carry > data like I am trying to. To get the correct number of days the formula is =B1-A1+1, where A1 is the start date and B1 is the end date. V From: Gord Dibben on 24 May 2010 19:26 Subtracting day one from day 365 will ALWAYS give you 364. Simple arithmetic. 10-1 = 9 12/31/2010 - 1/1/2010 = 364 Add 1 to the total. Gord Dibben MS Excel MVP On Mon, 24 May 2010 15:25:01 -0700, Working With Dates in Excel wrote: >Hello: > >I use Excel to keep up with information like the number of days I was >employed by a given employer. I included the first day of work on my >worksheet for example as 1/1/2010 then I type the last day I worked there for >example 12/31/2010. Now then with the first and last date displayed on my >sheet for common reference purposes I want to determine the total days I was >employed by this employer so I substract 12/31/2010 from 1/1/2010 but Excel >returns the value 364 when I was employed 365 days. In this example I would >not want to put 12/31/2009 as my first day of work or 1/1/2011as my last so >Excel would return the correct number of days which is 365 when I didn't work >there those days. Any info as how this should be done would be appreciated. I >would hope it would not require some complexed process to get Excel to carry >data like I am trying to.  |  Pages: 1 Prev: Need help looking up data-vlookup isn't workingNext: Progressive Chart