Future Date from value

[additude]

I have a number for example, 6.4 which relates to 6 days and .4 days.

I need to get this to a Date/Time value 6.4 days from NOW TODAY().

Please Login or Register  to view this content.

How can I get to this DATE/TIME?

Thanks.

[Ron Coderre]

First, a little about dates and Excel.

To Excel
Dates are represented by the number of days the date is from 31-DEC-1899.
01-JAN-1900........is 1.
01-AUG-2008.......is 39,661

Times are represented by decimal fractions of days.
0.5.......is 12 Noon
0.25.....is 6:00 AM
0.75.....is 6:00 PM

The Excel time value of 2:30 PM is...
=14.5 hours / 24 hours_in_a_day
=0.604166666666667

Alternatively, 0.4 of a day is...
=9:36 AM

So....If today is 01-AUG-2008, this formula:
=TODAY()+6.4
Returns: 8/7/08 9:36 AM

If you want 2:30 PM of today plus 6 days...
try this:
=TODAY()+6.604166666666667
or
=TODAY()+TIME(14,30,0)

Does that help?

[davesexcel]

I have a number for example, 6.4 which relates to 6 days and .4 days.

I need to get this to a Date/Time value 6.4 days from NOW TODAY().

Please Login or Register  to view this content.

How can I get to this DATE/TIME?

Thanks.

Hi additude
try
=now()+6.4

[additude]

Thanks Ron & Dave.

Simpler than I thought.

Appreciate.

Wes

[Simon Lloyd]

You can also use =Today()+6.4 then custom format the cell to dd/mm/yyyy hh:mm

Bear in mind you will get different results between using Now() and Today() as Now is a moveable time but Today is static.

[davesexcel]

Hi additude
try
=now()+6.4

That's funny, I thought I had deleted my answer after I saw Ron had answered it.....

[rlcohen70]

I am following this along, but what if I want to put a date into a cell and do not want to use the now ()
January 1, 2008 + 49 days or 7 weeks =
Then if the 49th day was on a Saturday or Sunday I need to roll over to the next closest Monday.

Next is I would like to provide a week number in the adjacent cell for the result.
So if the future date is March 15, 2008 I would like to see week number#22..

[daddylonglegs]

Hello rlcohen70,

Please start a new thread with your question, thank you