Find Jobs
Hire Freelancers

Annual Return Reminder - repost

$10-30 USD

Completed
Posted over 10 years ago

$10-30 USD

Paid on delivery
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 [login to view URL] 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.
Project ID: 4848550

About the project

3 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
It's done, available in pmb. It's a good exercise of formulating cells :)
$13 USD in 1 day
5.0 (85 reviews)
5.9
5.9
3 freelancers are bidding on average $19 USD for this job
User Avatar
Consider it done. Check your PM for my bid details
$30 USD in 1 day
4.9 (89 reviews)
5.8
5.8

About the client

Flag of HONG KONG
Hong Kong, Hong Kong
5.0
37
Member since Jul 4, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.