ExcelBanter - Count forward x days from date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count forward x days from date (https://www.excelbanter.com/excel-discussion-misc-queries/227507-count-forward-x-days-date.html)

helen

Count forward x days from date

(Excel 2003) I want to count 120 days forward from a certain date. Is there
a formula to return a new date?

Gary''s Student

Count forward x days from date

=A1+120 and format as date
--
Gary''s Student - gsnu200846

"Helen" wrote:

(Excel 2003) I want to count 120 days forward from a certain date. Is there
a formula to return a new date?

helen

Count forward x days from date

Thanks. Sometimes I try to make things so difficult!

"Gary''s Student" wrote:

=A1+120 and format as date
--
Gary''s Student - gsnu200846

"Helen" wrote:

(Excel 2003) I want to count 120 days forward from a certain date. Is there
a formula to return a new date?

Gary''s Student

Count forward x days from date

That's o.k.

It is easy to forget that days are just numbers.
--
Gary''s Student - gsnu200846

"Helen" wrote:

Thanks. Sometimes I try to make things so difficult!

"Gary''s Student" wrote:

=A1+120 and format as date
--
Gary''s Student - gsnu200846

"Helen" wrote:

(Excel 2003) I want to count 120 days forward from a certain date. Is there
a formula to return a new date?

All times are GMT +1. The time now is 12:03 AM.