Auto-fill or formula for dates

Hi, I've done a couple of searches through excelforum.com, but I can'
puzzle out what I need.

All I need is to fill one column with alternating rows of dates fro
Sunday through Friday. For example:

6/13/2004
6/14/2004
6/15/2004
6/16/2004
6/17/2004
6/20/2004
6/21/2004
6/22/2004
6/23/2004
6/24/2004
6/27/2004
and so on...


Thank you very much in advance,
Da

--
Message posted from http://www.ExcelForum.com

0
6/17/2004 4:32:05 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
308 Views

Similar Articles

[PageSpeed] 26

Hi Dan!

Your example and your words don't match.

In your example you want to get rid of 18 and 19-Jun-2004 which are 
Friday and Saturday.

To achieve that use:

=IF(WEEKDAY(B4)=5,B4+3,B4+1)

In your words, you just want to get rid of Saturday. To achieve that 
use:

=IF(WEEKDAY(A8)=6,A8+2,A8+1)

-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
"dfg >" <<dfg.1806zf@excelforum-nospam.com> wrote in message 
news:dfg.1806zf@excelforum-nospam.com...
> Hi, I've done a couple of searches through excelforum.com, but I 
> can't
> puzzle out what I need.
>
> All I need is to fill one column with alternating rows of dates from
> Sunday through Friday. For example:
>
> 6/13/2004
> 6/14/2004
> 6/15/2004
> 6/16/2004
> 6/17/2004
> 6/20/2004
> 6/21/2004
> 6/22/2004
> 6/23/2004
> 6/24/2004
> 6/27/2004
> and so on...
>
>
> Thank you very much in advance,
> Dan
>
>
> ---
> Message posted from http://www.ExcelForum.com/
> 


0
njharker (1646)
6/17/2004 4:52:37 PM
Thank you very much Mr. Harker!

And you're right, I goofed in my words. I meant Sunday through
*Thursday*. 
Thanks again for your help; I find it easier to learn formulas by
seeing them "in action", and this will surely prove useful in future
cases.

Cheers,
Dan


---
Message posted from http://www.ExcelForum.com/

0
6/17/2004 5:14:03 PM
Hi Dan!

No problem! It shows that giving examples of what you want is useful. 
Nuch too easy to make mistakes with wurds.

-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
"dfg >" <<dfg.1808xd@excelforum-nospam.com> wrote in message 
news:dfg.1808xd@excelforum-nospam.com...
> Thank you very much Mr. Harker!
>
> And you're right, I goofed in my words. I meant Sunday through
> *Thursday*.
> Thanks again for your help; I find it easier to learn formulas by
> seeing them "in action", and this will surely prove useful in future
> cases.
>
> Cheers,
> Dan
>
>
> ---
> Message posted from http://www.ExcelForum.com/
> 


0
njharker (1646)
6/17/2004 5:33:07 PM
Reply:

Similar Artilces:

Formula Question... LookUP
I am using the follwing formula to calculate the last entry in a range.. =LOOKUP(1,1/(1-ISBLANK('04&05 Details'!C416:C428)),'04&05 Details'!C416:C428) Is there a simple way to calculate the last but one ??? Any help greatly appreciated.. Thanks G, rephrase your question. I'm not sure what you mean by this. Are you trying to calculate its position on the worksheet? O -- Message posted via http://www.officekb.com Hi! >Is there a simple way to calculate the last but one ??? Does that mean if your formula returns the value in C420 you now want a formula ...

isv.config spontaneously rolls back to random date!
If I use deployment manager to publish changes to CR< then it appears that the isv.config file is replaced with an old version with n apparently random date. For example I currently have an isv.config file containing some changes made on 1/3/05. I then use deployment manager to add some more, unrelated, changes to CRM. When I now look for my changes in CRM they are missing and the isv.config file has been replaced with one dated 25/2/05. The changes made in deployment manager should not alter anything in isv.config. At present I backup the isv.config file and then restore just that after...

long datatype to date string
Hello, In my cell I have a long datatype value, like 1046101500. Now I want to have this converted to a date string like 'dd/m'/yyyy hh:mm:ss', so my example would be converted to '24/02/2003 15:45:00'. Is this possible? Andy Candy How does your data type correspond to the date? Where is the year? Month? etc. Andy. "Candy" <andy_hilvenNOSPAMPLEASE@hotmail.com> wrote in message news:3f729cad$0$814$ba620e4c@reader2.news.skynet.be... > Hello, > > In my cell I have a long datatype value, like 1046101500. Now I want to have > this converted to...

how to disable "auto repair" function in Excel XP?
I just bought a new PC with OEM Office XP standard version, before that I'm using my old PC with Office 97 standard version. I copied all of excel file to my new PC. Now, when I open any Excel (with MACRO), it said my Excel with something error and automatically repaired, I worry it will make any change of the excel files, it that possible to disable the "Auto Repair" function to let it stop to repair my files, thanks very much. I tried to send those files to another PC and tried to open via Excel 97, but it's still no any error. ...

Auto fill Column based on data in other columns
I have a report I'm downloading into Excel each day. Columns A, B, and C have the same number of rows populated. Columns D and E don't. I want to populate columns D and E with code the same number of rows Columns A, B and C are. I want to auto fill Column D with the text "ABCD" and Column E would be the current date in 06/05/06 format. I would like to put this code into an existing Macro. Any help you can give me is appreciated. Double click on the fill-handle http://www.mvps.org/dmcritchie/excel/fillhand.htm If you want to simulate with a macro Filldown as...

"Auto complete" function
Help me please!!! How can I turn off the "auto complete" function in Excel? Tell me the steps I have to do? Thanks : -- lex ----------------------------------------------------------------------- lexx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1549 View this thread: http://www.excelforum.com/showthread.php?threadid=27074 Tools - Options - Edit, There is a box at the bottom for Auto Complete unclick that, ???? -- scottymellot ----------------------------------------------------------------------- scottymelloty's Profile: http://www.excelfo...

Date Formatting #2
Is there a way to propogate the current date into a cell with just one key stroke? Hi Quick attempt, though I am sure you will get more detailed responses in due course. Assign a short cut key for a macro using the =Today() function, and format as required NB. will apply to active cell. Mathew "Parry" <purchasingtemp@fnf.com> wrote in message news:045e01c35c45$b7ce5f40$a301280a@phx.gbl... > Is there a way to propogate the current date into a cell > with just one key stroke? Parry, CTRL+; will insert the current date. CTLR+SHIFT+: will insert the current time. These ...

Filling an Autonumber 1-whatever down on a Sheet Programmatically
I have a Microsoft Query that retieves data from an Access Query an puts it into an Excel Worksheet named AllData starting at cell B2. have a sub named FormatDates that formats various column appropriately. What I need to do is add to this sub a procedur starting at cell a2 going down to the last row of data and filling number starting with 1 to howver many numbers of rows there are to thi last row Just like edit Fiil down when you have the number 1 and 2 highlighte and you fill down the range to the last row of data. Thanks Here is my sub below Sub FormatDates() Sheets(Array("Al...

x-axis dates
I have set up my line chart in 2007 with dynamic paramaters (names) and since then the date catagory is controlled by horizontal(values). The axis values are numbers even though the labels appear as dates. I have to use the microsoft numbers to determine the axis start and end limits. What happened? -- GeneS Perhaps I can better explain my problem. When I select the x-axis to reformat instructions are that I should be able to change axis type. That assumes I have horizontal (catagories) listed. I have horizontal(values) and there is no type to change. -- GeneS "Gene" ...

Frequency of date
I have a list of dates over a two year period (in this example it is over 2006-07; although it will vary given different data sets). I would like to create a table show the frequency of dates in each month. Jan -06 5 Feb -06 1 Is there an easy way to do this count. By far the easiest way is a pivot table. If you're new to Pivot Tables, start here: http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Fred. "PAL" <PAL@discussions.microsoft.com> wrote in message news:BCC5BB32-65E8-4621-B899-BB9558859E46@microsoft.com... >I have a ...

How do you insert a date time stamp into a CString?
Hi, I need to know, how would you properly insert the current date time as ( mmddyyyy_hhmm ) into a CString? Thanks in advance! Jaime Use CTime::Format ("%m%d%Y_%H%M"), it returns the formatted date/time as a CString object. e.g., CTime oTime (2003, 7, 11, 15, 38, 0); CString strDateTime = oTime.Format ("%m%d%Y_%H%M"); "Jaime Rios" <jaimer@nvision-tech.com> wrote in message news:<058901c347bb$a6cf0f30$a001280a@phx.gbl>... > Hi, > I need to know, how would you properly insert the current > date time as ( mmddyyyy_hhmm ) into a CStr...

Which Date does the system use for Date filter in Acvitities view?
CRM 3.0 Activity window in web client offers Date as a built in filter criteria. Which date does it use? It does not appear to use Due Date as the filter. The built in filter of Today vs Overdue does not bring up different result. How does this thing work? I ran into the same problem and found a hot fix that resolved the issue. You will need to contact Microsoft to have them send you the hot fix. http://support.microsoft.com/kb/917822 -M "Winnie" <Winnie@discussions.microsoft.com> wrote in message news:A6C32AE4-C44B-4B45-97E9-1E616E83C105@microsoft.com... CRM 3.0...

Finding Min In Calculated Pivot Table Formula
I didn't have much luck on another list, so I thought I'd try this one. Any thoughts on the below would be appreciated. I have a pivot table with a calculated field for which the equation is [Sum of Dollars / Count of Instances]. So in turn I'm rendering the average cost for a list of items in a group. The table is set up such that each column contains a week number and the rows contain a list of items within a grouping. For example, I might be listing average cost of apples, oranges, and peaches for each week under a grouping called fruit. The next grouping is bread, where I...

Compare sheet utility that can compare formula too
I am using MS Excel 2003 runs in vista. I need a utility program that can compare two worksheet, not only just the value but the formula as well. For instance: File 1: cell a = 5, b = 5, c = 5 , d = a + b = 10 File 2: cell a = 5, b = 5, c = 5 , d = a + c = 10 (note that d having same value as file 1 but formula is different) Will it be more reliable to use microsoft office product rather than 3rd party program? Any free MS product available for download? Regards, Adam, It is easy enough to do it quickly by hand. Copy the workbooks to preserve the originals, th...

Which formula do I need?
Hi! Would appreciate any help you can send my way: I have a sales spreadsheet showing sales per month for last year versus the current year. The data is input for all of last year and the data for the current year would be available through the current month. There are totals at the end of each row and I'd like the total for the prior year to add through the current month. Example: First Row: JAN thru DEC sales Second Row: JAN thru AUG sales The total column for the first row would only add the sales from JAN - AUG. I tried using SUMIF but don't think I...

IF/OR formula
I have this formula in a cell: =IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a") I also want to apply this formula to the same cell: =IF(F71="XL","--","") Both formulas work independently, but the first one is for if NUMBERS are entered in column F and the second formula is for if specific TEXT is entered in column F. How could I combine these two formulas? I think I need to have the formula first identify the type of contents in column F in order for this to work...? Thanks. Would =IF(ISNUMBER(H71),IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a&quo...

Sorting search results by date created for multiple file types?
I am trying sort files that were created in a certain folder since December 5, 2009 until the current date. These files can be of the following file extensions PDF, ZIP, RAR. The files should be sorted in descending date created order with the oldest files on top. This works when one file type is involved. However, when the "Date Created" column is clicked, with multiple files in the search results; it does not sort correctly in descending or ascending order. How do I make Window XP sort the file search results in descending "Date Created" order with multiple...

Budget dates
Is it possible to customize the dates in the budget, instead of having calender months? e.g. 010106 to 020606 Sorry no. -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny. I do not respond to any emails that I have not specifically asked for. "Boenerge" <Boenerge@discussions.microsoft.com> wrote in message news:64F0F8BF-B2A0-4E32-94EC-DE6DA5DEA798@microsoft.com... > Is it possible to customize the dates in the budget, instead of having > calender months? e.g. 010106 to 020606 ...

Text cell complains about date
I have a column containing ratios like 3/4, 3/0, 5/2, etc. I have them all formatted as text. All of the cells that have a zero as the second number (3/0) get a little green triangle and a warning that I have entered a "date string with only 2 digits for the year". Huh? How is "3/0" a date string with 2 digits for the year? And, why is it complaining about a text field? More importantly, how do I get Excel to stop being so "helpful" and leave my damned text data alone -- unexamined? Remove the warning in Options, Tools>Options>Error Checking in 2003...

Pattern Fill for lines with Vista
Hello, JoAnn, I hope you are there... I love Publisher (2007, well all of them), though not so sure about Vista, and this problem also occurs with Word. Anyway, if I want to print a shape that is filled, then, even with a plain colour fill, I have to go into Pattern Effects and ensure both the foreground and background colours are set to the colour that I want inside my printed shape. Note that the screen display is OK. Annoying... but it works! I also have to do the same procedure if I want to print a Line... funny really, because I only want a Line... I don't even want it 'fi...

Auto date changing in Excel is maddening
I'm using MS Office Excel 2003 (11.6113.5703) to post data that spans over several days. sample plot http://peswiki.com/index.php/Directory:Bedini_SG:Replications:PES:Sterling_Allan:Data:Exp10.4_Different_Standing_Discharge_Rates or try http://tinyurl.com/6f8zn We had to jump through all kinds of work-arounds in order to accomplish this. It was not a straight-forward process, though it should have been. When I enter the date format, for example, as Format > Time > 3/14/01 13:30 And then enter 11/17/04 0:30:30, it enters okay, but when I double click on the cell to edit it, Ex...

Formula #68
Hello, When ever I type a formula in a cell (For Ex: =sum(A63:A77)), I see the formula in the cell. I am not able to see the value (result) of the formula. I am not sure what setting was changed and how it was changed. Can you please let me know how to revert the settings so that I can see the resultant value of a formula in the cell? Thanks and Regards, Charles 1. clear the cell 2. Format > Cells... > Number > General 3. retype the formula (DON'T PASTE IT FROM ELSEWHERE) Your problem is probably that the format is Text. Good Luck -- Gary''s Student "Cha...

formula for subform nested into a subform
Hello!!!,,,I need an urgent help in a formula. I have the tables: [Ship] [Invoice] [Payments] IdShip (keyfield) ----------------> IdShip IdInvoice DateShipped IdInvoice (keyfield) ---------> AmountPaid Port AmountInvoiced DatePaid Customer DateInv I have a form A, which contains a key field &quo...

Linking sheets which must update the date first.
I have 50 clients, each with an Accounts Recievable worksheet. Past due is determined by using the =now and =today functions. This information is then linked to a Master sheet which displays all 50 clients at one time. The problem is: When I open the Master sheet, the dates on the 50 'feeder' sheets do not update the date. Only if those sheets are opened does the date update. Is there a command to open and close those 50 sheets or a recalculate command or perhaps, a macro is needed to open then close the 50 sheets. Any suggestions? I posted the same question abou...

Change the name of an auto save
I am trying to write a macro that will save the file to a specific cell reference. The reference is a specific name that is automatically generated by another macro function. Any suggestions on how I could do this? Cheers IS thsi what you want? Sub SaveMe() sFilename = Format(Worksheets("Sheet1").Range("A1").Value) ans = MsgBox("Save file as " & sFilename) If ans = vbOK Then ActiveWorkbook.SaveAs Filename:=sFilename End If End Sub HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Y...