QUESTION : I am using an IF function to insert a string into a cell if the cell specified is […]
Linux find files that differ from a given date
Problem : i would like to search for file that has not a give date. for example i want to […]
I know how to fix Excel dates stored as text, but *why* does it happen?
QUESTION : The question of how to handle dates stored as text in Excel is common, and so are the […]
Why won’t `date` accept it’s own default output?
Problem : On my system right now by default date outputs: $ date Fri 29 Jan 22:04:26 GMT 2016 However […]
Formula for Index/Match with multiple criteria WITH date range EXCEL
QUESTION : I am attempting to write a formula that will help pull data from column D into column H […]
Date reverts to current one in Windows Sandbox
QUESTION : I’m unable to change the current date in Windows Sandbox. I have disabled “Set time automatically” from the […]
Issue with calculating date/age in Excel
QUESTION : Doing a project and trying to currently work out age of subjects. I’ve tried using several formulas to […]
Add rows to insert dates from a “from” and “to” column
QUESTION : I want to breakdown an Excel sheet by having it in a specific format. Right now, the sheet […]
Excel – Find the document of a given type, with the closest due date
QUESTION : I am operating on 2 Tables. “Table 1” is a list of current documents that I import and […]
How to convert dates by working backwards from end of month?
QUESTION : I’d like to convert dates to weeks of month, but I’d like the weeks to be counted back […]