#ExcelTip dates are stored as numbers, so if u calculate with them, just got to format the answer so its a number not a date
Category: Excel
ProjectTip: E = Excel
#ProjectTip: E = Excel - plans in Excel, try manual scheduling in MSP 2010 to do more w/o the need to change how you work
Office 2011 (Mac) Courses
And here are the Office 2011 courses we are now offering. These outlines are suggested courses, but they can be customised to suit your needs and time requirements. These courses have been designed especially for Office 2011 for Mac courses and to give equivalent knowledge to our PC based courses of similar levels. We can … Continue reading Office 2011 (Mac) Courses
Calculate with Dates
One of the most asked questions during our Excel 2010 Training Courses has to be the subject of calculating with dates. Excel stores dates (and times) as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day (e.g. 31/10/2011 10:00 is stored as 40847.42).This is called a serial date, or serial … Continue reading Calculate with Dates
