| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date difference
Hi,
The following code will return the difference between the dates in N7 and R7: =IF(R7="","",DAYS360(N7,R7,TRUE)) It doesn't take into consideration weekends. Can this formula be changed to ignore weekends? -- tia Jock |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date difference
Try:-
=NETWORKDAYS(N7,R7) Mike "Jock" wrote: Hi, The following code will return the difference between the dates in N7 and R7: =IF(R7="","",DAYS360(N7,R7,TRUE)) It doesn't take into consideration weekends. Can this formula be changed to ignore weekends? -- tia Jock |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date difference
Hi Jock,
Look at the NETWORKDAYS() function. If you get a #NAME Error: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "Jock" wrote in message ... | Hi, | The following code will return the difference between the dates in N7 and R7: | =IF(R7="","",DAYS360(N7,R7,TRUE)) | It doesn't take into consideration weekends. | Can this formula be changed to ignore weekends? | -- | tia | | Jock |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date difference
Thanks Niek & Mike H.
Sorted. Jock "Niek Otten" wrote: Hi Jock, Look at the NETWORKDAYS() function. If you get a #NAME Error: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "Jock" wrote in message ... | Hi, | The following code will return the difference between the dates in N7 and R7: | =IF(R7="","",DAYS360(N7,R7,TRUE)) | It doesn't take into consideration weekends. | Can this formula be changed to ignore weekends? | -- | tia | | Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
| Difference System date and Excel Date function | Excel Worksheet Functions | |||
| Difference between last date of month and given date | Excel Worksheet Functions | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| Date difference | Excel Worksheet Functions | |||
Linear Mode
