About IT, web development, robotics and more.
You need to calculate a difference between two dates in excel. Guess what, Microsoft has a tutorial on how to calculate difference between dates in Excel. Woohoo! That’s gonna be easy you think. But wait. When following the instructions, Excel says, the DATEDIF function that you are trying to add, isn’t a function. Are you […]
This is a big nuisance with Microsoft Excel desktop version. I use Windows 7 and need to work with 3 separate Excel files simultaneously so I have them all open on my 2 screens. Excel by default opens them up ALL IN THE SAME WINDOW (wanna swear now, but keep reading). To open Excel files […]
Should you need to get random dates in Excel, here’s how to do it: Format the cells you are going to put the random dates in as “date”. To pick a random date, use the formulas RANDBETWEEN() or RAND() with specific parameters. The best way to generate dates is by subtracting random values from TODAY() […]