Annual Return Reminder - repost

In Progress

I need help displaying reminders based on how close the annual return date is to the current date. nnAll companies Limited by Shares (e.g cell C3) follow the A/R due date DATE(L3,K3,J3). nnAll companies that is Non-Hong Kong Company should follow the Inc/Reg date DATE(T12,S12, R12) and have the same reminder requirement as those Limited by SharesnnAll companies limited by guarantee also follow Inc/Reg date but only need to show reminder if less than one month from todays [url removed, login to view] am trying to get the formula to work for the last two conditions. As you can see, the problem starts at row 12 which is due to my formula. Any help will be much appreciated.

Skills: Excel

See more: excel based companies, excel help formula, return, Reminder, c3, excel date reminder, excel 2013 formula, conditions excel, reminder date, preparation annual report hong kong, annual, icentech limited hong kong, date reminder, dinball limited hong kong, editing translating technical documents hong kong dragon airlines limited, cotton work limited hong kong, street value limited hong kong, mmsi limited hong kong, noble house limited hong kong, uniea limited hong kong, hong kong cell

Project ID: #4848550

Awarded to:


It's done, available in pmb. It's a good exercise of formulating cells :)

$13 USD in 1 day
(85 Reviews)

3 freelancers are bidding on average $19 for this job


Consider it done. Check your PM for my bid details

$30 USD in 1 day
(89 Reviews)

let me help you.lets start!

$15 USD in 1 day
(0 Reviews)