i want to calculate , how many days in between two days. in excel
normaly we use DAYS360 but its not working how to calculate please help me
2006-07-23 20:12:56 · 8 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
just use the minus operator and then format it
If the two dates are in the cells A1 and A2. and u want the result in A3.
Type the formula =a2-a1 in the cell A3
select the cell A3 and using format->cells select the general number format
2006-07-23 20:16:38 · answer #1 · answered by Sunil 3 · 0⤊ 0⤋
The formula below returns the day of the year for a date in cell A1:
=A1-DATE(YEAR(A1),1,0)
Note: Excel automatically formats the cell as a date, so change the number format to another option (like General).
To calculate the number of days remaining in the year (assuming that the date is in cell A1), use the following formula:
=DATE(YEAR(A1),12,31)-A1
2006-07-23 20:20:55 · answer #2 · answered by Masud R. Khan 4 · 0⤊ 0⤋
Put the following:
A1= 1/1/2006
B1= 1/3/2006
C1= B1-A1
FORMAT C1 as NUBMERS! ( You may use also: C1=(B1-A1)+1 on some 'circumstances'.
2006-07-23 20:17:29 · answer #3 · answered by VBACCESSpert 5 · 0⤊ 0⤋
using excel, just use this formula
=Current date- other date
note: if the answer is in a date format just right click on the answer and then format it number- general
2006-07-23 20:16:18 · answer #4 · answered by judy 3 · 0⤊ 0⤋
What language/Application do you need the code for?
2006-07-23 20:15:33 · answer #5 · answered by Anonymous · 0⤊ 0⤋
"=C2-C3" where C2 and C3 are the cells where dates are entered. but c2 and c3 should be date format.
2006-07-23 20:16:50 · answer #6 · answered by rizz 2 · 0⤊ 0⤋
Gee, that's a doozie!!
2006-07-23 20:15:05 · answer #7 · answered by Jimmy Pete 5 · 0⤊ 0⤋
Well.....I don't kno but good luck!!!!
2006-07-23 20:15:54 · answer #8 · answered by Mellisa S 1 · 0⤊ 0⤋