How to calculate two dates in Excel

[Ektaa]

Hi friends,

I am facing an issue with Excel.I need to add two dates in Excel can anyone help me out with this following are my Details of my Spreadsheet.

1. Start Date is at B1.
2. End date is at C1.
3. I need to have the calculation at D1.

Thanks in Advance

Intel Dual core 2.66 Ghz
915 MSI Motherboard with Intel chipset
512 mb RAM
80gb HDD

[Clark]

Sure i will help you out with this issue may i know due you want to Exclude Weekends or not

[Ektaa]

Yes i need to exclude Saturday and Sunday from my calculation.

Intel Dual core 2.66 Ghz
915 MSI Motherboard with Intel chipset
512 mb RAM
80gb HDD

[Aarpitt]

Try to type copy the following in the formula bar.

=N((NETWORKDAYS(b1,c2)-(WEEKDAY(b1,2)<6)-(WEEKDAY(c2,2)<6))*9
+(WEEKDAY(b1,2)<6)*(NOT(ISNUMBER(MATCH(INT(b1),holidays,0))))*(MIN(MAX(0,TIME(17,30,0)-MOD(A1,1)),TIME(8,30,0)))*24
+(WEEKDAY(c2,2)<6)*(NOT(ISNUMBER(MATCH(INT(c2),holidays,0))))*(MIN(MAX(MOD(A2,1)-TIME(8,30,0),0),TIME(8,30,0)))*24
-SUMPRODUCT(--(WEEKDAY(holidays,2)<=5),--(ISNUMBER(MATCH(holidays,ROW(INDIRECT(INT(A1)+1&":"&INT(A2)-1)),0))))*9)

[Ektaa]

Thanks for you reply i try to copy paste the following but it didn't worked out for me any other solution please.


Intel Dual core 2.66 Ghz
915 MSI Motherboard with Intel chipset
512 mb RAM
80gb HDD

[Clark]

Try to use the NETWORKDAYS and MOD functions ia m sure it will work for you.Following are the formula:
=NETWORKDAYS(b2,c2)-1-MOD(b2,1)+MOD(c2,1)

And check this link too.

How to calculate duration in days