increment date by one day

Hello,

I'm trying to show a date in MM/DD format going across five cells that represent the days of the week. I want to calculate the correct date after entering a start date. For example:

I would modify the formula in cell B6 using the DATEVALUE formula by typing in a specific start date, such as:=DATEVALUE("6/30/2008")

I would then like cells E11:I11 to show:

E11: Mon,6/30
F11: Tues,7/1
G11: Wed,7/2
H11: Thurs,7/3
I11: Fri,7/4

I chose to use the DATEVALUE function because I read that it's easier to add dates when converted into their serial number equivalent. I would also like to do this without VBA, if possible. If I'm attempting this all wrong, feel free to point me to the right direction.

Appreciate the help!

Emil

Perhaps something like this....
With
E10: (any date....eg 7/9/2008)

This formula returns the Monday date of the week containing the date in E10

Please Login or Register  to view this content.

Next, to fill in the rest of the week:

Please Login or Register  to view this content.

Copy F11 across through I11

Last, make sure E11:I11 are formatted the way you want:
• Select E11:I11
• From the Excel Main Menu: <format><cells><number tab>
• Category: Custom
• Type: ddd, mm/dd <-(you'll need to type that part in)
• Click [OK]

In the above example, the formulas will return:

Please Login or Register  to view this content.

Is that something you can work with?

Please Login or Register  to view this content.

So...If you subtract a date's weekday_num from the date,
the result is the Sunday date prior to that date.

Adding 1 to that value is the Monday date for the week containing the date in E10.

Please Login or Register  to view this content.

Note: You can designate which day you want the week to start on
in the WEEKDAY function by setting the 2nd argument value.
See Excel Help on that function for the details.

I hope that helps.

You're correct...in that instance, there's no difference.
I don't routinely type the equal sign AND the leading plus sign (+).
It's probably there because I typed the plus sign then selected
cell E11 (and Excel put the equal sign in for me). Other times I may start
with the equal sign before selecting cells.

I hope that helps.