date-time Archives - IT Nursery

Linux – Forcing 24-hour locale?

Locales can be set for various components separately, so you can set LC_TIME to either “en_GB.UTF-8” (Great Britain), “en_DK.UTF-8” (Denmark – ISO 8601 … Read more

Change OS X date and time format in menu bar

by IT Nursery

There are 3rd party apps as Day 0. Check if it does what you want and if it is compatible with your version … Read more

Is there any way to view dates of changes to Windows registry keys/values?

by IT Nursery

Registry keys have a last-modified timestamp. You can use Regedit to export a key, selecting the “.txt” output format. That text file will … Read more

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?

by IT Nursery

If you have shown us the full range of possible formats, this should work: =TEXT(A1, IF(CELL(“format”,A1)=”D4″, “m/d/yy”, “General”)) If you have date formats … Read more

Calculate number of Sundays in the month

by IT Nursery

Try this where A1 is the starting day of the month: =SUMPRODUCT(N(TEXT(ROW(INDIRECT(A1&”:”&EOMONTH(A1,0))),”ddd”)=”Sun”)) You can also use this for any day of the week … Read more