98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Calculations
Calculations
Resolved · Low Priority · Version 2003
Antony has attended:
Excel Intermediate course
Calculations
How to best calculate working days in relation to calculating deadlines.
RE: Calculations
Dear Antony
Thank you for attending Excel Intermediate course. I hope you enjoyed the course and are finding the topics covered during the training useful.
I am hoping that you do understand that date calculations will be required.
If your query is specific to some scenario at work then please let me know.
It is quite straight forward to do a date calculation.
In one cell you enter a function called =Today() (this will ensure that the date will update everyday when the file is opened. It will take the date from your system so please ensure that your system date is curate).
On the other cell you enter may be the deadline date when you wish to complete a task
Do a simple subtraction formula between the two cells and you should get the results in days.
I hope this answers your query if you have further query then please hit the reply button and ask for further clarification!! If this has answered your question then may I please request you to mark this post as resolved!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Apply currency format quickly in ExcelTo quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $ |