| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calc days between two dates and exclude leap year days
Hi
I need to calculate number of days between two dates, over a period of yrs and discount the extra day in a leap year!!!! Any ideas anyone? Many thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calc days between two dates and exclude leap year days
Visit www.cpearson.com and see what Chip does with the undocumented DATEDIF
function. Not sure if he 'discounts' leap year. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "scoz" wrote in message ... Hi I need to calculate number of days between two dates, over a period of yrs and discount the extra day in a leap year!!!! Any ideas anyone? Many thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calc days between two dates and exclude leap year days
Many thanks Bernard, I'll have a look now
"Bernard Liengme" wrote: Visit www.cpearson.com and see what Chip does with the undocumented DATEDIF function. Not sure if he 'discounts' leap year. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "scoz" wrote in message ... Hi I need to calculate number of days between two dates, over a period of yrs and discount the extra day in a leap year!!!! Any ideas anyone? Many thanks in advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calc days between two dates and exclude leap year days
On Fri, 23 Nov 2007 05:02:18 -0800, scoz
wrote: Hi I need to calculate number of days between two dates, over a period of yrs and discount the extra day in a leap year!!!! Any ideas anyone? Many thanks in advance =A2-A1-SUMPRODUCT((MONTH(ROW( INDIRECT(A1&":"&A2)))=2)*(DAY(ROW( INDIRECT(A1&":"&A2)))=29)) where A1: Start Date A2: End Date --ron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calc days between two dates and exclude leap year days
Excellent Ron, Many thanks
"Ron Rosenfeld" wrote: On Fri, 23 Nov 2007 05:02:18 -0800, scoz wrote: Hi I need to calculate number of days between two dates, over a period of yrs and discount the extra day in a leap year!!!! Any ideas anyone? Many thanks in advance =A2-A1-SUMPRODUCT((MONTH(ROW( INDIRECT(A1&":"&A2)))=2)*(DAY(ROW( INDIRECT(A1&":"&A2)))=29)) where A1: Start Date A2: End Date --ron |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calc days between two dates and exclude leap year days
On Fri, 23 Nov 2007 07:18:00 -0800, scoz
wrote: Excellent Ron, Many thanks You're welcome. Glad to help. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) | Excel Discussion (Misc queries) | |||
| i have two days and i want the difference in days, months, year | Excel Worksheet Functions | |||
| How to calc # of days between two dates in YYYYMMDD in EXCEL. | Excel Discussion (Misc queries) | |||
| Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) | |||
Linear Mode
