Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by pecoflyer » Fri Oct 14, 2016 2:37 am
Hi
subtract the start date from the end date. That's it
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
by 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
-
angelic1
- Rookie
-
- Posts: 3
- Joined: Oct 13, 2016
- Reputation: 0
- Excel Version: 2010
by 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
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
by 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.
-
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 242 guests