How do you make an Excel function that converts dates?

Question

I have a spreadsheet where there is a date that I enter. I want to be able to make a function where upon entry of a date, on another column it automatically calculates the exact date which is 2 weeks later. How do you do this?

Answer 1

=cell that has the date in it + 14

Excel will know it's a date and make the new cell a date as well.

for example, if the date is in B7

=B7+14

Answer 2

You should be able to just add the number of days to the date you entered to get the new date (if you want 2 weeks after then you would add 14)

for example:

if you entered the date in A1 (1/1/2006)
in C1 you enter the following formula to calculate the date two weeks after:

=A1+14

This should work fine as long as you enter the date (in A1 in my example) in correct date format.

Answer 3

What you got after making use of the 'LEFT' functionality is a style 20060428 that may't be evaluated to a date with the help of Excel. Use Left or Mid to separate the style further into 3 hundred and sixty 5 days , month & date interior the subsequent 3 cells. Then use the '&' funtion to integrate the three, seperating them with '/' The date will then be evaluated. although if examine to work out how your gadget (homestead windows) handles dates - is it dd/mm/yy or mm/dd/yy - in the different case lower back the gadget will attempt to take 28 as month and supply an errors.

Answer 4

Excel has a terrific help system. Just type in your question and you will get the answer.

I typed in "how do you calculate time between dates" and got this

Refresh data at specific intervals
If the External Data Range Properties dialog box is not displayed, click a cell in the external data range, and then click Data Range Properties on the External Data toolbar.


Select the Refresh every box, and then enter the number of minutes between refreshes.

Hope that helps.

Everything on pc has great help system. If you can't think of another way just press F1...that is the universal help system.

Answer 5

Put the date in cell A1 and make sure it is formatted to date. Then in cell B1 type:

=A1+14

Excel will add 14 days to the date in cell A1.

If you want to be really funky, you can then select B1 and go to conditional formatting and set the font colour to white when cell A1 is blank, that way you will only see a value in cell B1 when there is something in A1 rather than a column of "14"'s.

Answer 6

There is a function you can use to extract the day out of the entire date. I believe it is Day(Date) that is if your date is in mmddyy format. Plus don't quote me on the exact name of the function. Either way, you extract the day and 14 to it and you should get the day it is in two weeks.

Answer 7

sit on the cell you want the (2 week) date at.
Click on the "E" for the formulas, then click on
the original cell w/ the original date and then
put in an addition sign (+) then type (14).

Your (2 week) cell's formula should look like
this: =SUM(A1+14)

Your telling it to add 14 days to the original (cell / date).
then just copy and paste the (2 week) cell all the way
down and it will automatically fill in when you type the
original date.

Answer 8

+"Cell#"+14