Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello - (XL2002 on XP)
I'm building a template to report daily sales and am looking for a way to calculate the DATE for each day of the current week. Here's what I have so far: cell J3: =NOW() (formatted to MM/DD/YY) K3: week # (calc'd using a really long formula, TOO long to write here) J9-J15: the days of the week K9-K15: this is where I want the dates for the current week to go So, as a real example, right the values should be: J3: 01/16/07 K3: 0703 J9: Sunday K9: 01/14/07 J10: Monday K10: 01/15/07 J11: Tuesday K11: 01/16/07 and so on.... What formulas would I put in K9:K15 to do this? OR, is there a better way to get the same end result? TIA, Ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
convert weekday date to the next sunday date | Excel Worksheet Functions | |||
Displaying Tuesday's date throughout the week | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Date & Day of Week | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |