Help needed regarding Date formulas/Formatting

Ray Zahir

I have a question regarding DATE formula, I have two Columns 1st one "Project Return" and 2nd one "Revised Project Due", is there a way that i manually put a date in first column and the 2nd column automatically calculates a date 7 days later (working)?

J. Craig Williams

Ray,

 

=[Project Return]23 + 7

 

for row 23 in the[Revised Project Due] column.

 

Craig

 

Ray Zahir

Thanks Craig will try it and let you know.