Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically putting in dates like tuesday/thursday
Myrna,
Thank you!!! Your formula worked perfectly for what I needed, using Sheet1's cell B1 as the start date. However, I am now trying to exclude specific dates calculated in my Sheet2's cells A3:A12, and I'm having trouble joining the two calculations. I've looked online, but all other topics discuss excluding weekends and don't take into account the WEEKDAY formula for Tuesdays/Thursdays. Help! :| Best, Gaby On Thursday, May 15, 2003 at 3:22:25 PM UTC-4, 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! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i monitor every tuesday and thursday xls now need next months | New Users to Excel | |||
Excel Bi-weekly time sheet change dates to Thursday- Wednesday? | New Users to Excel | |||
formulas populating dates - 1st Tuesday | Excel Worksheet Functions | |||
dates and 1st Tuesday of month | Excel Worksheet Functions | |||
Populating an excel calendar - eg. 10x tuesday/thursday from date x | Links and Linking in Excel |