Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding months to an inputted date
I need a function that will take a date that a user has typed in a different
cell and will then add two months to the date. For instance, if I type "2/12/05" in B1, then I want C2 to be: "4/12/05". Thank you for any help that you may be able to give. Logan |
#2
|
|||
|
|||
=DATE(YEAR(B1),MONTH(B1)+2,DAY(B1))
however what do you want the date to be in C2 if B1 is 01/30/05? Regards, Peo Sjoblom "BLW" wrote: I need a function that will take a date that a user has typed in a different cell and will then add two months to the date. For instance, if I type "2/12/05" in B1, then I want C2 to be: "4/12/05". Thank you for any help that you may be able to give. Logan |
#3
|
|||
|
|||
Hi Logan
=DATE(YEAR(B1),MONTH(B1)+1,DAY(B1)) HTH. Best wishes Harald "BLW" skrev i melding ... I need a function that will take a date that a user has typed in a different cell and will then add two months to the date. For instance, if I type "2/12/05" in B1, then I want C2 to be: "4/12/05". Thank you for any help that you may be able to give. Logan |
#4
|
|||
|
|||
Sorry. +2 of course.
Best wishes Harald "Harald Staff" skrev i melding ... Hi Logan =DATE(YEAR(B1),MONTH(B1)+1,DAY(B1)) HTH. Best wishes Harald "BLW" skrev i melding ... I need a function that will take a date that a user has typed in a different cell and will then add two months to the date. For instance, if I type "2/12/05" in B1, then I want C2 to be: "4/12/05". Thank you for any help that you may be able to give. Logan |
#5
|
|||
|
|||
however what do you want the date to be in C2 if B1 is
01/30/05? Since he's adding 2 months, you probably meant 12/30/2005, no? |
#6
|
|||
|
|||
Correct <g
-- Regards, Peo Sjoblom (No private emails please) "Myrna Larson" wrote in message ... however what do you want the date to be in C2 if B1 is 01/30/05? Since he's adding 2 months, you probably meant 12/30/2005, no? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
Excel Adding years or months to a date | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
Return a date 6 months from a date in another cell | Excel Worksheet Functions |