T
tjmartin00
I would like to put in a date & then have another column calculate 6 weeks
latter & another column 12 weeks latter.
latter & another column 12 weeks latter.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alan
With the date in A1
in B1 =A1 +42
in C1 =A1 + 84
Regards,
Alan.
in B1 =A1 +42
in C1 =A1 + 84
Regards,
Alan.
S
Sumika
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
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
F
Fred Smith
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.
work.
Try entering 9/30/05, and then add 28 (the number of days in 4 weeks) to it.
S
Sumika
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
worked,,, guess who is going to be the brain box of the office now,,,,,,,
Thank you