sumif by day of the year - repost

Closed

Description

We have recurring expenses that are due on certain days of the year. If the payment date falls on a weekend or holiday the payment will occur on the next business day after the weekend or holiday. I need a formula that will sum all payments due for a certain day of the year that will conform to the rules above. Please see attached example.

Skills: Excel

See more: year 2013, year, excel recurring, excel 2013 formula, Next Day , excel business expenses, expenses excel, recurring excel, date day, need posting site can good site please, example quarterly year day profitloss statement, day day expenses excel, year day expenses full graph, cfactory need convert vendor invoices excel attached sample, need convert vendor invoices excel attached sample, days sum excel, sum date excel, excel payment day, payment formula, excel formula day count mortgage payments, payment excel formula, excel payment formula, business day, payment formula excel, day excel payment formula

Project ID: #4464536

21 freelancers are bidding on average $49 for this job

Innovative116

Hi. can you please attached excel file. Thanks

$65 USD in 1 day
(65 Reviews)
6.7
bharanisrihari

Hello, Excel VBA expert here. It's a quick work for me. Please check PM for details. Thanks!

$55 USD in 3 days
(59 Reviews)
6.3
vserv

Hi, I specialize in Excel. Please see your messages. Thanks

$35 USD in 1 day
(54 Reviews)
5.6
nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Fixing of bugs and minor changes a More

$66 USD in 1 day
(40 Reviews)
5.6
mrbrave

Seems a quick task for Expert excel user....I would like to see original file before start.

$44 USD in 1 day
(71 Reviews)
5.3
HardWorker1989

Hello Sir. I placed my bid previously as well. I asked a question that you would like a macro in which the dates will automatically determine the day on that date and then mark the total as 0 and add it to anothe More

$147 USD in 3 days
(16 Reviews)
4.8
seaanddream

Hi, I bid your previous project as well. kindly let me know if you wish to work with a top-rated freelancer here... regards,

$49 USD in 3 days
(20 Reviews)
4.1
hemi

I am able to help you on this project. Please send actual file so I get back to you with proposed solution. Thank you

$40 USD in 1 day
(12 Reviews)
3.8
vikashgadia

we are excel expert wuld like to complete ur project as soon as possible

$35 USD in 0 days
(15 Reviews)
3.6
priyal1997

ITS DONE.. please check PM and confirm. Thanks - Priyal

$35 USD in 1 day
(11 Reviews)
3.6
nmlarsath

Why Not, Can you consider to solve this issue, and I could not fine the attachment please could you send again, Best Regards

$60 USD in 1 day
(7 Reviews)
2.7
SCRdataPro

I sent you a PM with the solution. Regards, Nico Vondegracht

$35 USD in 1 day
(1 Review)
2.5
haiyenle

I have perfect solution for you. Please check you PM, thanks

$35 USD in 2 days
(1 Review)
1.5
VBAExpress

Hello, I am specialist in MS Excel, VBA and scripts. Working on formulas like this is my job and my hobby. Hiring me is the right decision. :) Please check PM

$35 USD in 1 day
(1 Review)
0.3
ibmatharu

Hi, This can be easily done. Just one formula would give you the dynamic environment that you wish. Thanks.

$35 USD in 3 days
(0 Reviews)
0.0
Krombacher

Already have answer ready to go.

$35 USD in 1 day
(0 Reviews)
0.0
uokdilani

sir I'm ready.. I interest about this job

$35 USD in 5 days
(0 Reviews)
0.0
vsprybhanu

Hi, I'm VB.net programmer and can handle this project nicely. Expertise in Excel. Can you please attach your example. Thanks, Virendra

$45 USD in 3 days
(0 Reviews)
0.0
spateluc

I won't over-complicate this project with unnecessary code, and will work with you to deliver exactly what you are looking for. I have experience nesting Excel formulas together to create a simple solution that works More

$45 USD in 1 day
(0 Reviews)
0.0
ririemb

This is a quick and simple task. I'd love to do it for you. I'm a CPA from the United States and will return a quality product!

$35 USD in 1 day
(0 Reviews)
0.0