Date Formula

[srodkin]

Hi Everyone,

I am trying to create a date range for a work week. For example:

A1 4/18-4/22
B1 4/25-4/29

Is there a formula that will allow me to do this instead of physically typing in the weekly date range? I am currently using Excel 2007

Thank you

 

[daniels012]

The easiest answer would be to use 2 cells otherwise you would have to do some real manipulating and hard formulas.

If you had in A1 4/18/2011 and in B1 4/22/2011 then C1 would be A1+7 and D1+7 etc. etc.

Michael D

 

[T. Valko]

Hi Everyone,

I am trying to create a date range for a work week. For example:

A1 4/18-4/22
B1 4/25-4/29

Is there a formula that will allow me to do this instead of physically typing in the weekly date range? I am currently using Excel 2007

Thank you

Enter this first week in A1:

4/18 - 4/22

Enter this formula in B1 and copy across as needed:

=TEXT(LEFT(A1,FIND(" ",A1)-1)+7,"m/d")&" - "&TEXT(LEFT(A1,FIND(" ",A1)-1)+11,"m/d")

 

[lenze]

Place a start date in a n unused cell . Say A3. In A1, enter this formula

=TEXT($A$3+(COLUMN()-1)*7,"m/d/yy") & "--" & TEXT($A$3+(COLUMN()-1)*7+6,"m/d/yy")

and copy across. WHne done, paste special>values. You can now clear A3

lenze

 

[srodkin]

Thank you T Valko it works like a charm.

 

[T. Valko]

Thank you T Valko it works like a charm.

You're welcome. Thanks for the feedback!