Calculations

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Calculations

Antony has attended:
Excel Intermediate course

by - delegate Antony [1 post] (2008 Jul 1 Tue, 16:44) Reply

How to best calculate working days in relation to calculating deadlines.

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Calculations

by - trainer Rajeev gold contributer [462 posts] (2008 Jul 24 Thu, 11:35) Reply

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 by application

Main information pages

Calculations

Related articles

Excel tip:

Fill formulae across a sheet