[Solved] Calculating number of days /months & years between two dates?

Calculating number of days /months & years between two dates?

Dear all,
A1                      B2
Start date           End Date
19-Feb-10          31-Jul-10
I want to calculate the number of days, number of months & number of years between two dates.
in different columns as follows->
B3- Total Number of days between two dates (including start & end date)
B4- Total number of days between two dates including start and end date
& excluding holidays (saturdays & sundays).
B5- Total number of months (including start & end date)
B6- Total number of years (including start & end date) if found no difference of years it should display "0" years
 
Regards
Dharmesh

Solutions to the Problem Calculating number of days /months & years between two dates?

Download SmartPCFixer for Free Now

Dharmesh,
I think you need to take a bit more care in your posts to ensure that you ask the question you want the answer to in the first place, we will understand and if we don't we'll ask for clarification.
In order








Total Number of days Including Project Charge-in date & Project End date.









=B2-A2+1


Total Number of days Excluding Project Charge-in Date & Project End date.


=B2-A2-1


Total Number of days Including Project Charge-in Date &  End date & excluding Holidays (Saturdays & Sundays).


=NETWORKDAYS(A2,B2,Holidays)+1


Total Number of days Including Project Charge-in Date & End date & including Holidays (Saturdays & Sundays).


=B2-A2+1
Note this is the same as formula 1


Total Number of days Excluding Project Charge-in Date & End date & excluding Holidays (Saturdays & Sundays)


=NETWORKDAYS(A2,B2,Holidays)


Total Number of days Including Project Charge-in Date &  End date & excluding only SUNDAYS.


=(B2-A2+1)-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)=7))


Total Number of days Excluding Project Charge-in Date & End date & excluding only SUNDAYS.


=(B2-A2)-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)=7))
Edit.
1 formula edited
=(B2-A2+1)-SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)=7))

If this post answers your question, please mark it as the Answer.
Mike H

1. Access the files on your computer via MY COMPUTER
2. Under the C: drive, access the WINDOWS folder
3. Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
4. Delete any files within this download folder.
5. If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
6. Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.

Another Safe way to Repair the Problem: Calculating number of days /months & years between two dates?:

How to Fix Calculating number of days /months & years between two dates? with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.

Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v.2.2.0.0 driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v.2.2.3.0 driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v.2.0.6.22 driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v.1.1.88.1 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: Solution to Error: calculate difference between two dates in year, month and day in excel,Fast Solution to Error: Boxes with Red X's are appearing where words use to be?,[Solved] Browser is blocking access to Download Manager...,How Can You Fix - browzer zoom expands and shrinks my page constantly?,Troubleshoot:BSOD on new Win7 Pro x64 Error,All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work