Reputation
983
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 33 68
Impact
~518k people reached

Oct
29
asked Replace wiped BIOS on ASUS P5B-V motherboard
Oct
14
comment Excel: evaluating “January < now()” fails
My PC is configured with Australian dates.
Oct
14
comment Excel: evaluating “January < now()” fails
Apparently, from this question, I need to use today() instead of now(), but updating the formula with today() does not update the total past 0.
Oct
14
comment Excel: evaluating “January < now()” fails
Does your sheet work Kenneth? Can you save the sheet in your public Dropbox folder?
Oct
14
comment Excel: evaluating “January < now()” fails
Deleted the cell contents, and typed the date again, confirmed it is in short date format, and "Total" cell N4 remains 0.
Oct
14
comment Excel: evaluating “January < now()” fails
The cell B3 is not evaluated as a number, it remains 31/1/15.
Oct
14
comment Excel: evaluating “January < now()” fails
Thanks Kenneth. I've confirmed the cells B3 and rightwards are formatted as short date, entered the dates again, and the Total in cell N4 (containing the long formula) is still 0.
Oct
14
comment Excel: evaluating “January < now()” fails
I changed "January" to 31/1/2015, and the issue remained.
Oct
14
comment Excel: evaluating “January < now()” fails
@KennethL: see image above inside the question please.
Oct
14
revised Excel: evaluating “January < now()” fails
added detail
Oct
14
comment Excel: evaluating “January < now()” fails
No, I have empty cells in row 4. If I enter any numbers in those cells, nothing changes, so I'm assuming the IF test fails.
Oct
14
asked Excel: evaluating “January < now()” fails
Oct
4
accepted After Windows 10 wakes up, WIFI won't work
Oct
4
answered After Windows 10 wakes up, WIFI won't work
Sep
24
asked can users install browser add ons without admin privileges?
Sep
9
comment After Windows 10 wakes up, WIFI won't work
No, no docking station @Divin3.
Sep
7
comment Secondary mailbox reminders not popping up Outlook 2007
Unfortunately, you cannot add a 2nd Exchange account in Outlook 2007. Only 1 Exchange account is allowed per Outlook profile. I tried creating a secondary Outlook profile, but got stuck when working out the connection parameters to connect only to the shared mailbox.
Sep
4
comment After Windows 10 wakes up, WIFI won't work
There is no wireless section in mobility center when I open it, even now when wireless is working @Divin3
Sep
2
awarded  Popular Question
Aug
29
comment Secondary mailbox reminders not popping up Outlook 2007
Oh. Wicked. Thanks thims!