Excel date calculations 1

[cjbrown815]

Hello, Using Excel 2007

I want to enter a date in one column and have another column calculate 28 days earlier, the next to calculate 10 days later

Any ideas?

thanks


-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

hi,

if you date is in A2...
[tt]
=A2+28
next
=A2+10
[/tt]
or did you mean...
[tt]
B2: =A2+28
next
C2: =B2+10
[/tt]
??? Not clear

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

Thanks Skip, Its column C that has the date I punch in and column D + 28 should be the calculated column

Then I punch in todays date in Column M and its Column N + 10 days.

I do this every day and wanted it to calculate the duration for me. Currently I open Outlook and us the calendar. I thought there's got to be a better way


thanks again



-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

So is there still a question?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

Yes, How do I get it for the whole column? Your formula appears to be for a single cell.


thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

simply copy the cell and paste into a range.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

Thanks Skip, you Rock

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931