| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculating data
how can i calculate the final data betwen two cells?
for example in A1(date) i have 01/01/2005; in A2(numeric) i have 12(month) and in A3 i must have the final data 01/02/2006. thanks |
|
#2
|
|||
|
|||
|
calculating data
=DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))
-- Kind regards, Niek Otten "viktor" wrote in message ... how can i calculate the final data betwen two cells? for example in A1(date) i have 01/01/2005; in A2(numeric) i have 12(month) and in A3 i must have the final data 01/02/2006. thanks |
|
#3
|
|||
|
|||
|
calculating data
thanks for the formula;it's very good!
i have one more question: in A3 the calculation starts from A1 +1( if the A1=01/01/2005 in A3 i must have A2(12)+01/02/2005 thanks again! "Niek Otten" wrote: =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1)) -- Kind regards, Niek Otten "viktor" wrote in message ... how can i calculate the final data betwen two cells? for example in A1(date) i have 01/01/2005; in A2(numeric) i have 12(month) and in A3 i must have the final data 01/02/2006. thanks |
|
#4
|
|||
|
|||
|
calculating data
Not sure what you mean, Viktor, but maybe
=DATE(YEAR(A1),MONTH(A1)+A2+1,DAY(A1)) ? -- Kind regards, Niek Otten "viktor" wrote in message ... thanks for the formula;it's very good! i have one more question: in A3 the calculation starts from A1 +1( if the A1=01/01/2005 in A3 i must have A2(12)+01/02/2005 thanks again! "Niek Otten" wrote: =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1)) -- Kind regards, Niek Otten "viktor" wrote in message ... how can i calculate the final data betwen two cells? for example in A1(date) i have 01/01/2005; in A2(numeric) i have 12(month) and in A3 i must have the final data 01/02/2006. thanks |
|
#5
|
|||
|
|||
|
calculating data
i'm sorry for my poor explication; what i want to say is that in A3 the
calculation start with the next month from A1(ex.: A1=15/01/2005; A2=12(month) in A3 i must have 15/02/2005 plus 12 month = 15/02/2006) thanks again, viktor "Niek Otten" wrote: Not sure what you mean, Viktor, but maybe =DATE(YEAR(A1),MONTH(A1)+A2+1,DAY(A1)) ? -- Kind regards, Niek Otten "viktor" wrote in message ... thanks for the formula;it's very good! i have one more question: in A3 the calculation starts from A1 +1( if the A1=01/01/2005 in A3 i must have A2(12)+01/02/2005 thanks again! "Niek Otten" wrote: =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1)) -- Kind regards, Niek Otten "viktor" wrote in message ... how can i calculate the final data betwen two cells? for example in A1(date) i have 01/01/2005; in A2(numeric) i have 12(month) and in A3 i must have the final data 01/02/2006. thanks |
|
#6
|
|||
|
|||
|
calculating data
Niek's last suggested formula,
=DATE(YEAR(A1),MONTH(A1)+A2+1,DAY(A1)) Does *exactly* what you're asking for. Have you tried it? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "viktor" wrote in message ... i'm sorry for my poor explication; what i want to say is that in A3 the calculation start with the next month from A1(ex.: A1=15/01/2005; A2=12(month) in A3 i must have 15/02/2005 plus 12 month = 15/02/2006) thanks again, viktor "Niek Otten" wrote: Not sure what you mean, Viktor, but maybe =DATE(YEAR(A1),MONTH(A1)+A2+1,DAY(A1)) ? -- Kind regards, Niek Otten "viktor" wrote in message ... thanks for the formula;it's very good! i have one more question: in A3 the calculation starts from A1 +1( if the A1=01/01/2005 in A3 i must have A2(12)+01/02/2005 thanks again! "Niek Otten" wrote: =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1)) -- Kind regards, Niek Otten "viktor" wrote in message ... how can i calculate the final data betwen two cells? for example in A1(date) i have 01/01/2005; in A2(numeric) i have 12(month) and in A3 i must have the final data 01/02/2006. thanks |
|
#7
|
|||
|
|||
|
calculating data
In that case I think my answer was correct
-- Kind regards, Niek Otten "viktor" wrote in message ... i'm sorry for my poor explication; what i want to say is that in A3 the calculation start with the next month from A1(ex.: A1=15/01/2005; A2=12(month) in A3 i must have 15/02/2005 plus 12 month = 15/02/2006) thanks again, viktor "Niek Otten" wrote: Not sure what you mean, Viktor, but maybe =DATE(YEAR(A1),MONTH(A1)+A2+1,DAY(A1)) ? -- Kind regards, Niek Otten "viktor" wrote in message ... thanks for the formula;it's very good! i have one more question: in A3 the calculation starts from A1 +1( if the A1=01/01/2005 in A3 i must have A2(12)+01/02/2005 thanks again! "Niek Otten" wrote: =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1)) -- Kind regards, Niek Otten "viktor" wrote in message ... how can i calculate the final data betwen two cells? for example in A1(date) i have 01/01/2005; in A2(numeric) i have 12(month) and in A3 i must have the final data 01/02/2006. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Calculating time between successful data transmissions | Excel Discussion (Misc queries) | |||
| Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Linear Mode
