Formula Date

[Joko Purnomo]

How is the formula, 10 days from today to be 211 days in the future, in days months and years

Example :
Today : 10 days
Become : 211 days
When 211 days next, how to make formula dd/mm/yyyy in the future when 211 days from today

Please helm me sir

 

[Eric W]

Try:

=TODAY() + 211

then just use cell formatting to display it as dd/mm/yyyy.

 

[Joko Purnomo]

Try:

=TODAY() + 211

then just use cell formatting to display it as dd/mm/

Try:

=TODAY() + 211

then just use cell formatting to display it as dd/mm/yyyy.

In many case, today not always 10, always many

Example
10
21
12
8
10

When to become 211 in the future, in example above ? How the formula

 

[felixstraube]

Do you mean that if you start numbering the days from a certain start date, beginning with 1, like this:

And today is the day 10, then you want to know at what date will the day number 211 be?
If that's the case. Try this:

In column A you have differente day numbers for today. In B you get when the day 211 will be for each case with this formula in B2, and copy down:

=TODAY()-A2+211

 

[Joko Purnomo]

Do you mean that if you start numbering the days from a certain start date, beginning with 1, like this:

View attachment 105407

And today is the day 10, then you want to know at what date will the day number 211 be?
If that's the case. Try this:

View attachment 105408
In column A you have differente day numbers for today. In B you get when the day 211 will be for each case with this formula in B2, and copy down:

=TODAY()-A2+211

Thank very much

 

[felixstraube]

You are welcome.