New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

URGENT Help Please : calculate days between 2 dates for different / multiple Years

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

URGENT Help Please : calculate days between 2 dates for different / multiple Years

Postby angelic1 » Thu Oct 13, 2016 4:08 pm

I would like to calculate number of days between 2 dates which consists of 3 or 4 years together.... I would like to know days between each financial year eg. 1-March-16 to 5-April-17

financial year -------------days
April 2015- March 2016--- 31 days
Apr 16 to mar 17-----------365 days
Apr 17 to mar 18--------- 5 days

please help me with the nested if date formula.... I m finding it difficult to crack..

thank you!

http://www.ozgrid.com/forum/showthread.php?t=201453
http://www.excelforum.com/excel-general/1159690-urgent-help-please-calculate-days-between-2-dates.html
http://www.mrexcel.com/forum/excel-questions/970333-calculate-days-between-2-dates.html
  • 0

Last edited by angelic1 on Fri Oct 14, 2016 4:05 am, edited 1 time in total.
angelic1
Rookie
 
Posts: 3
Joined: Oct 13, 2016
Reputation: 0
Excel Version: 2010

Re: URGENT Help Please : calculate days between 2 dates for different / multiple Years

Postby pecoflyer » Fri Oct 14, 2016 2:37 am

Hi
subtract the start date from the end date. That's it
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: URGENT Help Please : calculate days between 2 dates for different / multiple Years

Postby angelic1 » Fri Oct 14, 2016 2:48 am

Thank you for replying, but this does not solve my purpose. I wanted to use IF & date function together in three different columns as below

Activation date -21-Mar-2016
Expiration date - 9-Apr-2016
total No Of Days - 20

f.y.2015-16 - 11
f.y.2016-17 - 9
f.y.2017-18 - 0
  • 0

angelic1
Rookie
 
Posts: 3
Joined: Oct 13, 2016
Reputation: 0
Excel Version: 2010

Re: URGENT Help Please : calculate days between 2 dates for different / multiple Years

Postby pecoflyer » Fri Oct 14, 2016 5:11 am

You will certainly find help with all your cross posts. I will not waste time on this.
Good luck
Cheers
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Re: URGENT Help Please : calculate days between 2 dates for different / multiple Years

Postby angelic1 » Fri Oct 14, 2016 5:19 am

This was my first time with getting helps from Forums & that being the reason i missed on certain guidelines and didnot adhere them. It would had been very helpful if u could have helped me with the solution. However, thank you for your valued time.
  • 0

angelic1
Rookie
 
Posts: 3
Joined: Oct 13, 2016
Reputation: 0
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 34 guests

cron