TechRepublic

Four ways to specify dates using Excel data validation

Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...
PC World

Use Excel’s DATE, WEEKDAY, IF, and IF/OR to make weekly schedules by task, event and team member

Excel’s SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions came to mind as I was watching a 1969 film called If It’s Tuesday, This Must Be Belgium, about American tourists on a whirlwind tour of ...
TechRepublic

How to extract the date and time from a serial date in Excel

How to extract the date and time from a serial date in Excel Your email has been sent Image: Rawpixel Ltd, Getty Images/iStockphoto Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft ...
PC World

Mastering Excel Date & Time: Serial numbers, Networkdays, Datevalue, and more

If you need to calculate dates in your spreadsheets, Excel uses its own unique system, which it calls Serial Numbers. Every date (month, day, year) and time (hour, minute, and second) has an ...
Geeky Gadgets

How to use Excel’s What-If data analysis tools (Goal Seek Scenario Manager)

When you use Excel, you have access to powerful tools that can help you make informed decisions based on different scenarios. Two of the most useful tools for this purpose are Goal Seek and the ...