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