Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding days correctly
Hi there, help please?? I am making a spreadsheet to show how many days a truck was used. If I subtract say B1 from A1 I get a number of days, but if its is actually a day off. If we use something from 4/10/2006 to 4/10/2006 I want to get an answer of 1 day, not 0. I have tried the basic subtraction & the DAYS360, but am not finding what to you all must be an oh-so-simple solution. Any help would be greatly appreciated. Céline -- wistfulee ------------------------------------------------------------------------ wistfulee's Profile: http://www.excelforum.com/member.php...o&userid=33626 View this thread: http://www.excelforum.com/showthread...hreadid=533985 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding days correctly
Maybe just subtract the dates and add one?
=a1-b1+1 wistfulee wrote: Hi there, help please?? I am making a spreadsheet to show how many days a truck was used. If I subtract say B1 from A1 I get a number of days, but if its is actually a day off. If we use something from 4/10/2006 to 4/10/2006 I want to get an answer of 1 day, not 0. I have tried the basic subtraction & the DAYS360, but am not finding what to you all must be an oh-so-simple solution. Any help would be greatly appreciated. Céline -- wistfulee ------------------------------------------------------------------------ wistfulee's Profile: http://www.excelforum.com/member.php...o&userid=33626 View this thread: http://www.excelforum.com/showthread...hreadid=533985 -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding days correctly
Wist--
I see the problem -- you're thinking of 4/10 as both the beginning and ending, but Excel isn't smart enough to see that. If you're consistently off by one day, why can't you just do the subtraction and then add 1? HTH "wistfulee" wrote: Hi there, help please?? I am making a spreadsheet to show how many days a truck was used. If I subtract say B1 from A1 I get a number of days, but if its is actually a day off. If we use something from 4/10/2006 to 4/10/2006 I want to get an answer of 1 day, not 0. I have tried the basic subtraction & the DAYS360, but am not finding what to you all must be an oh-so-simple solution. Any help would be greatly appreciated. CĂ©line -- wistfulee ------------------------------------------------------------------------ wistfulee's Profile: http://www.excelforum.com/member.php...o&userid=33626 View this thread: http://www.excelforum.com/showthread...hreadid=533985 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding days correctly
=A1-B1+1 Format as general or as a number -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=533985 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding days correctly
I guess I was overthinking the issue. Thank you from a very tired lady. -- wistfulee ------------------------------------------------------------------------ wistfulee's Profile: http://www.excelforum.com/member.php...o&userid=33626 View this thread: http://www.excelforum.com/showthread...hreadid=533985 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
Adding Working Days to a Formula | Excel Discussion (Misc queries) | |||
add days without adding weekend | New Users to Excel | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Adding Days (i.e. Mon, Tue, Wed, Thur...) to sheet | Excel Discussion (Misc queries) |