Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating only weekdays
I need to enter the date for weekdays only across columns in numerous
worksheets. How can i get the dates for monday thru fridays only stating with the date in B1? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating only weekdays
Enter the first date in B1. This must be a Monday thru Friday date.
Enter this formula in C1 and copy across as needed: =B1+CHOOSE(WEEKDAY(B1),0,1,1,1,1,3) -- Biff Microsoft Excel MVP "Sinkguy1" wrote in message ... I need to enter the date for weekdays only across columns in numerous worksheets. How can i get the dates for monday thru fridays only stating with the date in B1? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating only weekdays
With your first date in A1 enter this in B1 and copy across columns...
Excel 2007 =WORKDAY(A1,1) Excel 2003 =IF(WEEKDAY(A1+1,2)<6,A1+1,A1+3) "Sinkguy1" wrote: I need to enter the date for weekdays only across columns in numerous worksheets. How can i get the dates for monday thru fridays only stating with the date in B1? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating only weekdays
Thanks, I am using 2007 and that was easy. The discription of the function
did not sound like that was what I wanted, but it works great. "Sheeloo" wrote: With your first date in A1 enter this in B1 and copy across columns... Excel 2007 =WORKDAY(A1,1) Excel 2003 =IF(WEEKDAY(A1+1,2)<6,A1+1,A1+3) "Sinkguy1" wrote: I need to enter the date for weekdays only across columns in numerous worksheets. How can i get the dates for monday thru fridays only stating with the date in B1? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating only weekdays
Thanks, See reply from Sheeloo. It was shorter and does work.
"T. Valko" wrote: Enter the first date in B1. This must be a Monday thru Friday date. Enter this formula in C1 and copy across as needed: =B1+CHOOSE(WEEKDAY(B1),0,1,1,1,1,3) -- Biff Microsoft Excel MVP "Sinkguy1" wrote in message ... I need to enter the date for weekdays only across columns in numerous worksheets. How can i get the dates for monday thru fridays only stating with the date in B1? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating only weekdays
Yeah, I didn't even think of using WORKDAY.
Thanks for the feedback! -- Biff Microsoft Excel MVP "Sinkguy1" wrote in message ... Thanks, See reply from Sheeloo. It was shorter and does work. "T. Valko" wrote: Enter the first date in B1. This must be a Monday thru Friday date. Enter this formula in C1 and copy across as needed: =B1+CHOOSE(WEEKDAY(B1),0,1,1,1,1,3) -- Biff Microsoft Excel MVP "Sinkguy1" wrote in message ... I need to enter the date for weekdays only across columns in numerous worksheets. How can i get the dates for monday thru fridays only stating with the date in B1? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating only weekdays
Hi,
Enter the first date in cell B1. Now drag down (a couple of rows) the fill handle at the lower right corner of cell B1 and then release it. You will see a "Auto Fills Option" box. Click on it, and there will be an option for weekdays. This assumes Mon-Fri as weekdays. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Sinkguy1" wrote in message ... I need to enter the date for weekdays only across columns in numerous worksheets. How can i get the dates for monday thru fridays only stating with the date in B1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weekdays | Excel Discussion (Misc queries) | |||
Weekdays calculation | Excel Worksheet Functions | |||
Weekdays only! | Excel Discussion (Misc queries) | |||
WEEKENDS VS. WEEKDAYS | Excel Discussion (Misc queries) | |||
Weekdays | Excel Discussion (Misc queries) |