Menu
Microsoft Excel has two different date systems that you will probably never think about because they exist in two different worlds: Windows or Mac. However, if you are sharing Excel files between Windows and Mac computers the potential exists for a great deal of confusion around dates.
This tutorial: A quick look at setting up a simple spreadsheet in Excel complete with a chart. More tutorials to follow that will go into more detail on how to use the different features of MS Excel. Open Microsoft Excel on your Mac or PC. Double click on the program to open it. Save your Excel file in a format compatible with the other person's version of Excel.
What is a Date System?
Dates are represented in Excel by a numbering system. Days are assigned whole numbers, known as serial numbers, because the basic unit of time in Excel is the day. Each date system has a base date, or starting date, represented by the number 1.
The Windows date system has a starting date of January 1, 1900 that is given the serial number 1. The next day, January 2, is serial number 2, and so on.
The starting date in the Macintosh date system is January 2, 1904, which is given the serial number 1. The next day, January 3, is represented by serial number 2, etc.
Default Date Systems for Windows and Mac
The default workbook setting in Microsoft Excel 2010 is the 1900 date system. In the Excel Options dialogue box you are given the option to Use the 1904 system, should you so desire.
As you can see below, Microsoft Excel for Mac 2008 has the 1904 date system as the default workbook setting. By un-checking this option the workbook will use the 1900 date system.
Problems Mixing Excel Date Systems
A major problem can occur if you copy or use a formula reference to dates from a workbook with one date system to a workbook with another date system. Since the two date systems use different base dates they show up as different formatted dates.
Some explanation here would be helpful.
Well known to Excel geeks, the serial number 40,000 is formatted as 7/6/2009 in the Windows 1900 date system. However, the same 40,000 serial number is formatted as 7/7/2013 in the 1904 date system. Same serial number, different formatted date. Note: I’m using the date convention m/d/yyyy.
If I copy the date 1/15/2010 from a Mac to a Windows version of Excel the formatted date will appear as 1/14/2006, yet the underlying serial number is 38731 in both versions. This happens because the two date systems have a difference of 1,462 days between the start dates.
In the picture below there are two worksheets. The one on the left, Date Test Windows.xlsx, was created in Excel 2007 (Windows) and the one on the right, Date Date Test Mac.xlsx, was created using Excel for Mac 2008.
In column A of both worksheets I entered a series of dates from 1/1/2010 to 1/15/2010. The last row’s cell formatting has been changed to “General” so you can see the underlying serial date for 1/15/2010.
In column B of both worksheets I used a formula to reference column A of the other worksheet so you can how the same serial number is represented differently by each date system. For reference: on the Date Test Window worksheet, the formula in cell B16 is ='[Date Test Mac.xlsx]Sheet1′!A16′.
Working with Windows and Mac Versions of Excel
One time a colleague of mine started a data collection worksheet using Excel for Mac and one of the data fields was the date. After data had been collected for over a week I realized the workbook was using the 1904 date system.
Knowing the file would be used exclusively on Windows computers I endeavored to change the date system setting and realized there would have to be some conversion of the existing data. In a different column I simply entered a formula to subtract 1,462 from the existing dates, copied, and then pasted as values. Next I un-checked the box for the 1904 date system and used the new date column.
My recommendation is to be aware if the Excel file you are using has come from a Mac and if so, check out which date system is being used. If the file will be used primarily on Windows computers then it’s best to use the 1900 date system.
Be careful when changing the settings for the date system because the dates will change for any current data in the workbook. If you have dates you need to convert from one system to another, adding or subtracting 1,462 to the dates can give you a quick solution for what I call date dementia.
Microsoft Excel Preview is the official application of Microsoft Excel for Android terminals, which will allow us to view, edit and create spreadsheets from our tablet with Android operating system. It is important to be clear on this point: Microsoft Excel Preview is only compatible with tablets.
Microsoft Excel Preview users will be able to open spreadsheets stored in their account, create new spreadsheets, and of course edit any file in Excel format. In addition, we can always continue to work exactly where we left off, since Microsoft Excel Preview will recognize which worksheet was last modified, regardless of the device from which we were working. And with Microsoft Excel Preview we can have all our spreadsheets synchronized, both in our Microsoft account and in other alternative services like Dropbox. Thanks to this we will never have to worry about losing our progress with any work.
Microsoft Excel Preview is an excellent spreadsheet application that has everything you could want inside an official application.
More from Us: Bring! Grocery Shopping List For PC (Windows & MAC).
Here we will show you today How can you Download and Install Productivity App Microsoft Excel on PC running any OS including Windows and MAC variants, however, if you are interested in other apps, visit our site about Android Apps on PC and locate your favorite ones, without further ado, let us continue.
More from Us: Bring! Grocery Shopping List For PC (Windows & MAC).
Here we will show you today How can you Download and Install Productivity App Microsoft Excel on PC running any OS including Windows and MAC variants, however, if you are interested in other apps, visit our site about Android Apps on PC and locate your favorite ones, without further ado, let us continue.
Microsoft Excel on PC (Windows / MAC)
- Download and install BlueStacks or Remix OS Player.
- Open the installed BlueStacks or Remix OS Player and open the Google Play Store in it.
- Now search for “Microsoft Excel” using the Play Store.
- Install the game and open the app drawer or all apps in the emulator.
- Click Microsoft Excel icon to open it, follow the on-screen instructions to play it.
- You can also download Microsoft Excel APK and installs via APK in the BlueStacks Android emulator.
- You can also use Andy OS to install Microsoft Excel for PC.
That’s All for the guide on Microsoft Excel For PC (Windows & MAC), follow our Blog on social media for more Creative and juicy Apps and Games. For Android and iOS please follow the links below to Download the Apps on respective OS.
You may also be interested in: IPhone 8: codes indicate that Apple Pay could be authenticated without Touch ID.
Microsoft Excel for Android:
Price: Free+
A Professional Business Analyst, Tech Author and Writer since 2013. Always talking about Tech and innovation in both Software and Hardware worlds. Majorly Expert in Windows and Android, Software, Mobile Apps and Video Marketing. You can Reach on me on Social Media.