| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate the difference between two dates, excluding Sund.
Using Excel, need to calculate the difference between two dates, excluding
Sundays . |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calculate the difference between two dates, excluding Sund.
Take a look at this link. Specificaly there is a funciton for counting the
number of Mondays in an interval (you can change it for Sunday). Then it is just a matter of subtracting the number of sundays from the total number of days... -- HTH... Jim Thomlinson "gwatt" wrote: Using Excel, need to calculate the difference between two dates, excluding Sundays . |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calculate the difference between two dates, excluding Sund.
One way:
A1 = start date A2 = end date =A2-A1-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=1)) -- Biff Microsoft Excel MVP "gwatt" wrote in message ... Using Excel, need to calculate the difference between two dates, excluding Sundays . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calculate the difference between two dates, excluding S
Jim, thanks for responding. the function sounds like it will work.
however, I do not see the "link" ? where do I find this function? Thanks. "Jim Thomlinson" wrote: Take a look at this link. Specificaly there is a funciton for counting the number of Mondays in an interval (you can change it for Sunday). Then it is just a matter of subtracting the number of sundays from the total number of days... -- HTH... Jim Thomlinson "gwatt" wrote: Using Excel, need to calculate the difference between two dates, excluding Sundays . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calculate the difference between two dates, excluding Sund.
Or, you could just count all the days that *aren't* Sundays then subtract 1:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)<7))-1 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... One way: A1 = start date A2 = end date =A2-A1-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=1)) -- Biff Microsoft Excel MVP "gwatt" wrote in message ... Using Excel, need to calculate the difference between two dates, excluding Sundays . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calculate the difference between two dates, excluding Sund.
Try this "daddylonglegs" formula
A1 = start date B1 = end date =SUM(INT((WEEKDAY(A1-{2,3,4,5,6,7})+B1-A1)/7)) "gwatt" wrote: Using Excel, need to calculate the difference between two dates, excluding Sundays . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to calculate the difference between two dates, excluding S
Great, Thanks. I subtracted one to get the actual day's lapsed.
"Narasimha" wrote: Try this "daddylonglegs" formula A1 = start date B1 = end date =SUM(INT((WEEKDAY(A1-{2,3,4,5,6,7})+B1-A1)/7)) "gwatt" wrote: Using Excel, need to calculate the difference between two dates, excluding Sundays . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| How do I calculate the difference between 2 dates (m,d,y) ? | Excel Worksheet Functions | |||
| Calculate Difference b/e 2 dates. | New Users to Excel | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| Calculate difference between two dates | Excel Worksheet Functions | |||
Linear Mode
