View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Service Date changing

What are you trying to do?
Adding 69 to your date adds 69 days to your date. What are you trying to
calculate? What result do you expect you should get?
--
** John C **


"Pammy" wrote:

I have a spreadsheet:
N R S
T
Service Dates" , "Hours Worked 2008" Days answer Rounded
Ans
5/4/2004 551.00 =R3/8 68.875
=roundup(S2,0) 69

Now I need to add the 69 to the Service Date to get a new date, so in column
U would the formula be = N2+T2

7/13/2004 is the answer I get, is this the correct way?