Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add dates (mo/day/yr + 6 wks) in Excel ?
I would like to put in a date & then have another column calculate 6 weeks
latter & another column 12 weeks latter. |
#2
|
|||
|
|||
With the date in A1
in B1 =A1 +42 in C1 =A1 + 84 Regards, Alan. "tjmartin00" wrote in message ... I would like to put in a date & then have another column calculate 6 weeks latter & another column 12 weeks latter. |
#3
|
|||
|
|||
I also need to use this function, I have tried your suggestion and I keep
getting the VALUE in the cell I need the date + x weeks Below is what I am trying to do: Date date +4 weeks date + 6 weeks 9.30.05 #VALUE! Hope you can help Su "Alan" wrote: With the date in A1 in B1 =A1 +42 in C1 =A1 + 84 Regards, Alan. "tjmartin00" wrote in message ... I would like to put in a date & then have another column calculate 6 weeks latter & another column 12 weeks latter. |
#4
|
|||
|
|||
You need to have a true Excel date in your cell in order for date formulas to
work. Try entering 9/30/05, and then add 28 (the number of days in 4 weeks) to it. -- Regards, Fred "Sumika" wrote in message ... I also need to use this function, I have tried your suggestion and I keep getting the VALUE in the cell I need the date + x weeks Below is what I am trying to do: Date date +4 weeks date + 6 weeks 9.30.05 #VALUE! Hope you can help Su "Alan" wrote: With the date in A1 in B1 =A1 +42 in C1 =A1 + 84 Regards, Alan. "tjmartin00" wrote in message ... I would like to put in a date & then have another column calculate 6 weeks latter & another column 12 weeks latter. |
#5
|
|||
|
|||
Thank you Thank you Thank you,,,,, I changed it as you suggested and it
worked,,, guess who is going to be the brain box of the office now,,,,,,, Thank you "Fred Smith" wrote: You need to have a true Excel date in your cell in order for date formulas to work. Try entering 9/30/05, and then add 28 (the number of days in 4 weeks) to it. -- Regards, Fred "Sumika" wrote in message ... I also need to use this function, I have tried your suggestion and I keep getting the VALUE in the cell I need the date + x weeks Below is what I am trying to do: Date date +4 weeks date + 6 weeks 9.30.05 #VALUE! Hope you can help Su "Alan" wrote: With the date in A1 in B1 =A1 +42 in C1 =A1 + 84 Regards, Alan. "tjmartin00" wrote in message ... I would like to put in a date & then have another column calculate 6 weeks latter & another column 12 weeks latter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
dates in Excel 2003 | Excel Discussion (Misc queries) | |||
how do I show dates in a column in an excel worksheet? | Excel Discussion (Misc queries) |