| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL
I need to create a formula to increment the date on a column by 25 months
on another column |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL
SorianoP wrote:
I need to create a formula to increment the date on a column by 25 months on another column Hi SorianoP, try with this: =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1)) where in A1 is your starting date and in A2 the number of months to add to initial date. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL
=DATE(YEAR(A1),MONTH(A1)+25,DAY(A1))
-- Kind regards, Niek Otten Microsoft MVP - Excel "SorianoP" wrote in message ... |I need to create a formula to increment the date on a column by 25 months | on another column | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL
Hi Franz,
Thanks for your help...I really appreciate it. "Franz Verga" wrote: SorianoP wrote: I need to create a formula to increment the date on a column by 25 months on another column Hi SorianoP, try with this: =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1)) where in A1 is your starting date and in A2 the number of months to add to initial date. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL
Thank You very much Niek...
"Niek Otten" wrote: =DATE(YEAR(A1),MONTH(A1)+25,DAY(A1)) -- Kind regards, Niek Otten Microsoft MVP - Excel "SorianoP" wrote in message ... |I need to create a formula to increment the date on a column by 25 months | on another column | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formula that adds 7 days to a cell when sheet is copied | Excel Worksheet Functions | |||
| Change cell in formula based on date | Excel Discussion (Misc queries) | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
| date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
| Formula to calucate # of months based on a speificed date entered | Excel Worksheet Functions | |||
Linear Mode
