• ## Other - General

### Forum Guide

by Published on 2016-11-07 12:48 AM

Getting the Most From Excelguru Forums
We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

How the Forum Works

Using the Forum
Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

1. Register
2. Activate

If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm that you’re a real person. ...
• ### Recent Forum Posts

#### Excel Loosing External Source Links, Have to Relink Every Time it Opens

What do you mean opening the links? I've opened the source spreadsheet and it still doesn't link. I do not know what references the spreadsheet is having...

Ruth2002 Today, 11:09 AM

#### Need a formula that calculates how many days in a given month between two given dates

Thank you. I will supply a spreadsheet when I get back to my computer. To respond to your questions, the months in row 1 can be any format you tell that...

elik Today, 01:33 AM

#### Need a formula that calculates how many days in a given month between two given dates

Can't tell what's in D1,E1,F1 etc. Is it a real excel date formatted to show just month and year or is it just a literal string (if you're lucky, it might...

p45cal Today, 12:47 AM

#### Filter a Date column using VBA

oh groan…
Filter a Date column using VBA | MrExcel Message Board

p45cal Today, 12:24 AM

#### Appending the Cells Interior.Color reference to the cell value

run after you've selected the cells you want to process:

Code:
```Sub blah()
For Each cll In Selection.Cells
cll.Value = cll.Value & "|"```
...

p45cal Today, 12:15 AM