Forum home » Delegate support and help forum » Microsoft Excel Training and help » General Query

General Query

ResolvedVersion 2003

Thu 12 Feb 2009, 15:49 Delegate Kathryn said...

Kathryn has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course

General Query

I'm sure I am going to have a question in the future at work but I can't think of one now? Thank you

Fri 13 Feb 2009, 08:58 Trainer Amanda said...

RE: General Query

Hello Kathryn

Thank you for your post.

If you have any questions you would like to post in future, please log into your delegate account via our web site to use the forum again.

Kind regards
Amanda

Thu 19 Feb 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

General Query

General Query

RE: General Query

Excel articles

Excel tip:

Formula for last day of month