Excel formula
This query is : Resolved
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
=10000*(31/03/2010-01/04/2009+1/365*12%
please let me know the role of "+1" in the above formula
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)
Like (March to march =13 month)
01 January 2010
Agree with the expert
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Tds on building rent monthly
- RCM INVOICING FROM NOV-2024
- GST Regis.
- Sale of property furniture sale
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- COP Surrender 2024
- Regarding Waiver of Interest levied u/s 50 of PGST/CGST Act
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
Trending Online Classes
CAclubindia
