+ Reply to Thread
Results 1 to 1 of 1

Day late

  1. #1
    Registered User
    Join Date
    02-22-2014
    Location
    Vung tau
    MS-Off Ver
    Excel 2003
    Posts
    19

    Day late

    Hi everybody, i want to calculate Day late of Declarations.
    15Q1 means Quarter 1 of 2015, deadline of declaration is 04/05/2015.
    1501 means January, 2015
    3501846769 is tax identification of A Company. It has been established 10/06/2015 ( which belongs to Quarter 2 of 2015). So, the first declaration of operational status must been sent before 30/07/2015.
    At T156, "home" means A hasn't been operated. in 15q2, it sent a declaration, 15q2 is also the first period to calculate Day late.

    Sheet An ( answer) has just shown late day which value >0. I need some help
    1. 3501901586 has wrong value, because it is established in 2016, so in 2015 there has no declaration.
    2. Today is 29/02/2016, deadline of 15Q4. If any company doesn't send declaration, just sign "k"
    Thanks.
    Attached Files Attached Files
    Last edited by mai07; 02-29-2016 at 12:46 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If every 5 days late . . .
    By morerockin in forum Excel General
    Replies: 6
    Last Post: 02-10-2015, 10:09 PM
  2. A little late - Hi!
    By dmersinger in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-23-2013, 10:13 AM
  3. Better late than never or ??
    By Alf in forum The Water Cooler
    Replies: 8
    Last Post: 08-01-2013, 08:47 PM
  4. Late binding - help please?
    By aertanconfin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-29-2012, 09:41 AM
  5. My late comer welcome
    By PearlySWO in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-11-2012, 11:25 PM
  6. [SOLVED] Late Binding
    By Mark in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2005, 11:05 AM
  7. Late Binding or Late Anything
    By Piranha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2005, 10:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1