| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formula excluding 1 day
Hello:
I'm looking for a formula that would reflect the following: saterday - thursday. Should only reflect days from above but skip friday when drag/drop through the column. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula excluding 1 day
Hi,
Put your start date in (say) A1 and this in A2 and drag down =IF(WEEKDAY(A1)+1<5,A1+1,A1+2) Mike "art" wrote: Hello: I'm looking for a formula that would reflect the following: saterday - thursday. Should only reflect days from above but skip friday when drag/drop through the column. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula excluding 1 day
Thanks, just needed to change one small part,
=IF(WEEKDAY(A1,2)+1<5,A1+1,A1+2) otherwise it would skip thursdays not fridays. Thanks anyways. "Mike H" wrote: Hi, Put your start date in (say) A1 and this in A2 and drag down =IF(WEEKDAY(A1)+1<5,A1+1,A1+2) Mike "art" wrote: Hello: I'm looking for a formula that would reflect the following: saterday - thursday. Should only reflect days from above but skip friday when drag/drop through the column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Date Formula Excluding Weekends | Excel Discussion (Misc queries) | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Due date excluding weekend days | Excel Worksheet Functions | |||
Linear Mode
