Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 23rd 19, 06:37 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2019
Posts: 1
Default automatically putting in dates like tuesday/thursday

On Thursday, May 15, 2003 at 1:19:23 PM UTC-6, Myrna Larson wrote:
What pattern do you want? Just Tues and Thurs every week? Excel can't handle that with automatic
incrementing since the increment is 2, 5, 2, 5, etc.

You can do it with a formula:

Put the first date (a Tue or Thu) in A1. In A2

=A1+IF(WEEKDAY(A1)=3,2,5)

and copy down.


On Thu, 15 May 2003 05:53:39 -0700, "John" wrote:

or Monday Wednesday...

if i enter a date in one cell and then drag the cell it
will want to enter dates sequentially...but there must be
some easy way to enter a different pattern...

help! thanks in advance!



This was very helpful, thank you!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically putting in dates like tuesday/thursday [email protected] Excel Worksheet Functions 0 January 26th 17 09:07 PM
automatically putting in dates like tuesday/thursday [email protected] Excel Worksheet Functions 0 March 26th 15 03:51 PM
i monitor every tuesday and thursday xls now need next months tutorisland New Users to Excel 1 May 23rd 08 02:30 AM
dates and 1st Tuesday of month Jessica[_2_] Excel Worksheet Functions 11 July 17th 07 11:13 PM
Populating an excel calendar - eg. 10x tuesday/thursday from date x [email protected] Links and Linking in Excel 0 September 28th 06 10:00 AM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017