Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello everyone.
I have a column of "begining" dates and another column with "ending" dates. I'd like Excel to calculate the weekdays between the two dates. For example, in the first cell in column A I would have 10/01/03 and in the first cell of column B I would have 10/16/03. I'd like Excel to give me the number of weekdays within this time span, which in this case would be 12. BUT, if the the "ending" date is empty I'd like Excel to provide "today's" date. I don't know if this can be done. Any help any of you could provide would be very much appreciated. JZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round dates to weekdays | Excel Worksheet Functions | |||
Weekdays between two dates in Excel? | Excel Discussion (Misc queries) | |||
Difference (weekdays) between two dates | Excel Worksheet Functions | |||
How do i count number of weekdays between two dates? | Excel Worksheet Functions | |||
Fill dates with weekdays/workdays only | Excel Worksheet Functions |