Easy Office
Easy Office

Excel formula

This query is : Resolved 
Profile Image

Profile Image

(Querist)
31 December 2009 Please help on this excel formula :
=10000*(31/03/2010-01/04/2009+1/365*12%

please let me know the role of "+1" in the above formula
Profile Image

Ram Avtar Singh

Profile Image

Ram Avtar Singh (Expert)
31 December 2009 It will always calculate 364 days but year is 365 days so it will use for correct days calculation

Like (March to march =13 month)
Profile Image

CA Deepak S

Profile Image

CA Deepak S (Expert)
01 January 2010 Agree with the expert
Upgrade to CAclubindia Pro. Subscribe Now!


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries


CCI Pro

Trending Online Classes

view all classess


Answer Query



Quick Links