Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More date issues
I should probably gather a bunch of my problems and ask about them all at once
I have a row of cells that are column headers for the days of the week. Before each day(text) is a blank cell for the date(03/01/04). I would like to be able to enter the date in the first blank date cell and have the other 6 fill automatically. The closest built in formula I could find was Workday(), but that only accounts for Mon - Fri. I need to figure all seven days of the week Erik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
More date issues
Hi Erik
enter the first date in a cell (lets say in A1) and enter the following formula in B1 =A1+1 format this as date and copy to the left -- Regards Frank Kabel Frankfurt, Germany Erik wrote: I should probably gather a bunch of my problems and ask about them all at once. I have a row of cells that are column headers for the days of the week. Before each day(text) is a blank cell for the date(03/01/04). I would like to be able to enter the date in the first blank date cell and have the other 6 fill automatically. The closest built in formula I could find was Workday(), but that only accounts for Mon - Fri. I need to figure all seven days of the week. Erik |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
More date issues
Hi Erik
Enter a date in -say- A1. In cell A2 put the formula =A1+1 and in A3 the formula =A2+1 ....and so on. 1 is a day in Excel. -- HTH. Best wishes Harald Followup to newsgroup only please. "Erik" wrote in message ... I should probably gather a bunch of my problems and ask about them all at once. I have a row of cells that are column headers for the days of the week. Before each day(text) is a blank cell for the date(03/01/04). I would like to be able to enter the date in the first blank date cell and have the other 6 fill automatically. The closest built in formula I could find was Workday(), but that only accounts for Mon - Fri. I need to figure all seven days of the week. Erik |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
More date issues
You're welcome Erik.
Don't be ashamed. Date and time in Excel, and other MS apps, is very simple, but not intuitive and not obvious. I think it's the topic that generates most newsgroup questions. -- HTH. Best wishes Harald Followup to newsgroup only please "Erik" skrev i melding ... That was so easy I'm ashamed of myself for not thinking of it. Once again, thank you. Erik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date issues | Excel Discussion (Misc queries) | |||
date issues. HELP!!! | Charts and Charting in Excel | |||
date computing and sum issues | Excel Worksheet Functions | |||
date calculation issues | Excel Discussion (Misc queries) | |||
date calculation issues | Excel Worksheet Functions |