Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Need Date Formula from start date to 120 days later to calculate new date
1,631 views
Skip to first unread message
Sandra De Pasquale
Mar 27, 2003, 6:52:36 PM3/27/03
to
I need to know how to create a date formula which will
take various start dates and add 120 days to that and give
me the new dates (automatically). Please provide specific
instructions or attach a document in which the formula has
been created. I do not understand if I need to convert
dates to numbers and then add the formula and if so, how
do you convert back to dates, etc.? I lack the knowlegdge
to perform this function. Can you help me?
Sandra
take various start dates and add 120 days to that and give
me the new dates (automatically). Please provide specific
instructions or attach a document in which the formula has
been created. I do not understand if I need to convert
dates to numbers and then add the formula and if so, how
do you convert back to dates, etc.? I lack the knowlegdge
to perform this function. Can you help me?
Sandra
Jason Morin
Mar 27, 2003, 7:11:40 PM3/27/03
to
If your date is in A1, then in another cell put:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+120)
and press enter. Format this cell as mm/dd/yy if necessary.
HTH
Jason
Atlanta, GA
>.
>
JJ
Mar 27, 2003, 7:34:12 PM3/27/03
to
all these are formatted as mm/dd/yyyy
in A1 => 3/20/1962
in B1 => =A1 + 120 which will show up as 7/18/62
exactly 120 days after
JJ XL2002
"Sandra De Pasquale" <Sandra.d...@farmersinsurance.com> wrote in
message news:023801c2f4bb$f1991b80$a401...@phx.gbl...
Jason Morin
Mar 27, 2003, 8:04:04 PM3/27/03
to
Geez, what was I thinking? Just add 120.
Jason
>.
>
0 new messages