Date Formula

[skip2mylew]

I need a formula to show an entire week in one cell. I know how to add dates together but I'm not sure how to add entire weeks together.

This is what a cell would look like...

August 24th - August 30th

Then, the cells after this cell should show the next week, and the week after, etc.

[FDibbins]

August 24 to August 30 is only 6 days

to get the date a week later, just add 7 to the date

[jeffr27]

Are the dates entered anywhere on the workbook? If so you could use the Concatenate function.
Column A has the week start date, column B has the week end date, column C has =CONCATENATE(A1&" - "&B1).
The dates would need to be in the "mmmm dd" format.

[shyamhappy]

Please Login or Register  to view this content.

Please try this function. Enter the date in the D9 - 24/08/2013.
___________________________________________________________________________________________________________________________________
Please click * to say thank you

[amy_d2]

Hi skip2mylew

in B5 put any week starter date (i.e. 26 Aug 13)

in C5 =TEXT(B5,"MMMM dd")&" - "&TEXT(B5+7,"MMMM dd")

in D5 =TEXT(B5+8,"MMMM dd")&" - "&TEXT((B5+8)+7,"MMMM dd")

in E5 =TEXT(B5+16,"MMMM dd")&" - "&TEXT((B5+16)+7,"MMMM dd")

in F5 =TEXT(B5+24,"MMMM dd")&" - "&TEXT((B5+24)+7,"MMMM dd")

pl confirm if this is what you want ..... or pls send your sample of data structure will provide u solution accordingly

[skip2mylew]

August 24 to August 30 is 7 days.. 24th, 25th 26th, 27th, 28th, 29th, 30th

amy_d2 is used your formula and adjusted it a little. Here's what I have:

Please Login or Register  to view this content.

[FDibbins]

August 24 to August 30 is 7 days.. 24th, 25th 26th, 27th, 28th, 29th, 30th

I understand what you are saying, but 30-24=6, not 7