• Home
  • Live Training
    • EXCEL Live
    • Word Live
    • XERO Live
    • MYOB Live
    • One On One Live
  • Class Training
    • Corporate Staff Training
    • EXCEL Training Cairns
    • MYOB Training Cairns
    • Outlook Cairns
    • PowerPoint Cairns
    • WORD Training Cairns
    • XERO Training Cairns
    • Registration Form
    • FAQ
  • Bookkeeping
  • Gallery
  • Contact us
    • Join our Community
    • Blog
    • Resources
Smart Biz HQ
Phone: 0428 411 050

EXCEL Count Days Function

21/8/2019

0 Comments

 
EXCEL Efficiencies
Can you believe it is August already?
Have you got that BIG dream holiday planned?  Or started the countdown till the fat man sings?
Here is a great EXCEL formula to count the number of days between dates.
 
=DAYS()
Example.  Type todays date in cell A1, and December 25, 2018 in A2
=DAYS(A2, A1)

The formula has to begin with the later date (A2).  If you get the answer as a negative number--reversing the order of cells should give you a positive number.

OK so there are ONLY 127 days until Christmas!  Holy Moly, I hear you say!
​
Picture
​So how many workdays (Monday to Fridays)?

=NETWORKDAYS()
Nett work days
Use ascending order to avoid a negative result

​Example. NETWORKDAYS(A5, A6)
Just 92 work days


Picture
​Let the countdown begin till our ADVANCED EXCEL program in Cairns on Friday, 30 August 2019.

Just 9 days to go.

Woot, woot and we still have a few seats left. But get in quick or miss out on obtaining more of these great efficiencies in this powerful program!
0 Comments



Leave a Reply.

    Author

    Julie Goleby B.A. Voc. Ed,
    ​Dip. Accounting & Business

    She is passionate about helping SMB's understand their financials and grow their business!

    Archives

    October 2019
    September 2019
    August 2019
    May 2019
    February 2019
    December 2018
    June 2018
    May 2018
    March 2018
    January 2018

    Categories

    All

    RSS Feed

Location

What Our Clients Are Saying

​"I felt the experience was beneficial for our team.  Julie was confident, clear and concise which made the training easy." Sarah
"Great to have plenty of opportunity to practice on different files and exercises.  Clear and interesting presentations."Cat
"Experience was good. Presenter was clear and explained it all in detail while avoiding confusion. " Chloe
"Been informative whilst relaxed and professional.  Easy to follow and understand, and open to help when queries were asked."  Gizelle
Ready VET  Atherton

Contact Us

    Enquire Today

Send