| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
I am enter a date in a cell and in another cell i would like to input a
formula that will add or substract 6 months or more from the orginal date cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
One way:
A1: <date A2: =DATE(YEAR(A1),MONTH(A1)-6,DAY(A1)) Note that months are squirrely concepts... In article , VAP wrote: I am enter a date in a cell and in another cell i would like to input a formula that will add or substract 6 months or more from the orginal date cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
-- Gary''s Student - gsnu200738 "VAP" wrote: I am enter a date in a cell and in another cell i would like to input a formula that will add or substract 6 months or more from the orginal date cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
