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!
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!
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
=NETWORKDAYS()
Nett work days
Use ascending order to avoid a negative result
Example. NETWORKDAYS(A5, A6)
Just 92 work days
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!
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!
RSS Feed