Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why won't it Excel fill in weekly dates now, changes them to daily
I'm using Excel 2004 for Mac. I'm trying to fill in a column with
week-ending dates. I put in each date for the first few times, then do a fill and it only does daily dates. I hold down the control key, and it gives me a menu that includes daily, weekdays, months, years, but no weeks. I am fairly certain that Excel used to do this easily, but it isn't doing it now. |
#2
|
|||
|
|||
One way:
Place the first week-ending date in a cell. Then do Edit - Fill - Series. Set the increment to 7. HTH Otto "Larry" wrote in message ... I'm using Excel 2004 for Mac. I'm trying to fill in a column with week-ending dates. I put in each date for the first few times, then do a fill and it only does daily dates. I hold down the control key, and it gives me a menu that includes daily, weekdays, months, years, but no weeks. I am fairly certain that Excel used to do this easily, but it isn't doing it now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fractions turn into dates when pasting in excel 2003 | Excel Discussion (Misc queries) | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
How do I convert an excel worksheet to a fill in form? | Excel Discussion (Misc queries) | |||
- colour fill in excel | Excel Discussion (Misc queries) | |||
can I customize cell fill patterns in Excel? | Excel Discussion (Misc queries) |