ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   automatically putting in dates like tuesday/thursday (https://www.excelbanter.com/excel-worksheet-functions/454522-re-automatically-putting-dates-like-tuesday-thursday.html)

[email protected]

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! :)


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com