add a date without holidays
I have a problem, in a macro I need to calculate a date adding working days
This add not include saturday / sundays and holidays.
21/5 + 6 days = 31/5
How i can to do ?
Thanks in advance and sorry by my english,
For adding days, use the DateAdd function. It won't return an invalid date
The Weekday function returns the number of the day, for instance this
returns 6 for Saturday, tomorrow it will return 7 for Sunday.
For holidays I can't help...Lookup for oldest date among different dates
I badly need your help in the below formula
Structure : Account includes Sub-accounts and each sub-account includes dials
Formula : Account activation date = Oldest Sub-account activation date
where there is more than one account and hence different activation
date for each account and in turn the sub-accounts that belong to each account
Below the example
A B C D
Account # Sub-Account # Account Sub-account
...How do I customize fields in a "desin form"
I am trying to design my own contact form but am unsure how to do it. I want
to remove some ifields that are there by default, and add some fields of my
own. For example, I am trying to create a form for family members,, so I'd
like to remove business phone # and replace with cell #, and remove company
name, and replace with spouse.
Any helf is greatly appreciated.
Then you would want to post your question in the programming group.
"shellnbreeze" <email@example.com> wrote in message
news:1B7ED1F0-CD...How to create a calendar from date information in XL sheet.
I have an XL spreadsheet that contains multiple columns,
one of which contains data in date & time format. Is
there a way to export this data and associated information
from the record to another application, for example Word,
and create a calendar? Any suggestions how to manipulate
this XL data are welcomed. Thanks!
...Edit formula while entering Excel 2000
Is there a way, such as a key combination of enabling the cursor to navigate
a formula or line of data while composing it, before its actually entered,
and without going to the formula bar to do it?
Yeah....I know its niggly, but its niggled me for a long time :-)
basicly 2 ways to do it. in the formula bar or directly in cell.
you seems to know about the formual bar so to edit directly in cell....
on the menu bar>tools>options>edit tab>check edit directly in cell.
> Is there a way, such as a key combination of enabl...Field promotion in a Report.
I have a Table - Quiery an a Report.
The Reports contain fields:
If this was mailmerge in Word and Adr2 field was empty I would have this
information in the letter:
Is it possible to do so in the Report?
Best Regards from
On Fri, 18 Jan 2008 23:13:10 +0100, Joergen Bondesen wrote:
> Hi NG.
> I have a Table - Quiery an a Report.
> The Reports contain fields:
> If this was mailmerge in Word and Adr2 field was e...Text in formula?
What a pain in the neck to come back home after being away and not
being able to access the newsgroups via my newsreader (http://
www.gmayor.com/MSNews.htm). Anyway ... <g>
I have this formula in cell A16:
="Don't take today: " &+A15+1
I got it from googling for text and formulas in same cell. I've tried
formatting cell as general and text but nothing comes out right.
The result in A16 should say:
Don't take today: Tue.Sep.14.2010 but instead it says:
Don't take today: 40435
Can anyone advise how to fix this?
On Mon, 30 Aug 2010 ...Support for custom look up fields
I am dissappointed to learn the MS CRM 3.0 do not support custom made look up
fields at a more profound level. I do acknowledge the work done on solving
some of the issues concerning relationships between accounts and contact etc.
through the relationship entity , but this solution still seems much more
complex to manage in comparison to the possibility of simply creating and
adding custom look up fields to your forms and thereby managing relationships
- just the same way as pointing out a "primary contact" person.
This post is a suggestion for Microsoft, and ...Current Date 01-20-10
I would like to filter on todays date. What is the field name for the
current date. Thanks.
Try "Current Date."
- Andrew Lavinsky
> I would like to filter on todays date. What is the field name for the
> current date. Thanks.
Does anyone have a formula set up scorekeeping in Excel for the game
Rummikub. We have tournaments and want to use the computer to keep track of
scores, with minus scores added to the winners' scores. Thanks
...How Excel converts % sign in a cell and use in formula
I am trying to figure out a formula in Excel that I know is simple, but it's
I understand about the order of operations and what has to happen first and
the absolute cell reference. I'm confused about what the 1 is in the
(1+$F$9)...the info in cell F9 is sales tax and is written as 8.25%.
Thanks in advance for the help.
Peggy Duncan, Author
Conquer Email Overload with Outlook
> I am trying to figure out a formula in Excel that I know is simple, but it's
> been years....
> ...repeating formulas by the same row or colum increment as the last.
I need to repeat formulas in a sheet by the same #of rows. I mean I might
increase the copied value by 22 rows. How can I enter that without typing
each row increment
I have a cell with a simple currency formula in it. I want to add a specific
dollar amount to the formula result IF a single value from a group of 5
values appears in another cell.
Thank you. John Q.
Without more details, maybe something like:
John Q wrote:
> I have a cell with a simple currency formula in it. I want to add a specific
> dollar amount to the formula result IF a single value from a group of 5
> values appears in another cell.
> Thank you. John Q.
-...need help with Index, Match and Countif in the same complicated formula
I have a spreadsheet Expense Journal designed for entering expenses in two
currencies, one for Dollar and one for a local currency. It has two sections
of rows, the top is for Dollar Expenses and uses no exchange figures
because the spreadsheet converts everything to Dollars. This Dollar section
has five columns:
Date Project # Account # Description Dollar
In the blank spreadsheet that they start anew each quarter, there are only
two rows setup for Dollar expenses because most of their expenses will be in
Below the Dollar secti...How to apply a formula accross all the rows when the total rows are too much in no. ?
guyz i know you can drag the formula accross the rows in that column t
have that formula in effect in every cell. but i have some data lik
5000 rows then how to get that formula accross each cell, its painfu
holding the mouse and dragging the formula accross the rows.
thanks in advance
Message posted from http://www.ExcelForum.com
after inserting this formula in the first row double click on the lower
right corner of your cell selection
> guyz i know you can drag the formula accross the rows in that col...Date an time on WinXP.
Does anyone know where windows Xp gets the time and date it displays from?
My system date and time often fails, resulting in the time beiing 5-5mn
delayed compared to what
it shoul have been . I wonder what can cause that????
...Importing CSV file field mapping
When importing a CSV file for contacts or leads: How can
I expand the drop down list of field choices under the
Microsoft CRM fields to included fields such as Account,
alternative address information, etc.?
The current limited amount of fields keeps me from
importing information currently contained within our
Outlook based contact system. What I do to expand the
number of fields exported from Outlook is to Export the
contact records from Outlook to MS Access, then export
the access contact table as a CSV file. This process
gives me more information to import (i.e., other
addres...Formulas to run offline in 3.0?
Hi CRM Pros
I have a prospective 3.0 customer. Basically they have a not too
complex Excel sheet, that they would like to replace with CRM
functionalty instead, in order to run it offline with automatic sync to
the CRM server. I know that I can customize CRM 3.0 with extra fields
on the oppertunity entity and with custom exchange rate and freight
rate tables. But what are the possibilities in 3.0 of creating
calculations to run automatically, e.g., tallying the sum of some of
the custom fields, or for multiplying some of them together with the
exhange rate from a separate table? These calcula...Multiple date validation in a single cell
I am trying to do a rather complicated validation (I think it i
I want to allow ONLY dates of a particular format to be entered int
the one cell - i.e. YYYY OR mm/YYYY OR dd/mm/YYYY
For example, the same cell can have either one of these format
entered, but MUST match one of them to be accepted.
1970 is OK and is captured in the cell as 1970 (not 1/01/1970)
70 is assumed to mean 1970 on entry
05/1970 is OK, captured in the cell as 05/1970 (not 1/05/1970)
5/70 or May-70 is assumed to mean 05/0970 on entry
05/06/2004 is OK
5/6/04 or 5 June 04 is assumed to mean 05/06/2004 on entr...in formula a range cell reference eg) $A1:$A20 that is static when filling
if i want a cell reference to not increment when filling i put a
dollar sign in front of it
i noticed this does not work when you specify a range of cells eg )
$A1:$A20 although it is not an error
when i fill in a formula it still increments the cell reference in
each row but if i specify a single cell it does not.
does anyone know the syntax for this, it's hard to word so i havent
been able to find anything on google.
thanks for your help!
You mean like this:
P...Another question regarding Dates..
First, thanks to the replies to my previous post.
How can I work out the day & month when I only know the Year and Day Number?
Year = 2004
day number = 302
The answer I'm looking for is 28/10/2004
Again, taking into consideration the leap years
Thanks again in advance
"Anthony Slater" wrote:
> First, thanks to the replies to my previous post.
> How can I work out the day & month when I only know the Year and Day Number?
> Year = 2004
> day number = 302
> The answer I'...Date format 03-03-08
How do I get a date to print as mm-dd-yy in a field?
On Sun, 02 Mar 2008 23:43:02 -0500, BC wrote:
> How do I get a date to print as mm-dd-yy in a field?
Set the format property of the Date control to:
Please respond only to this newsgroup.
I do not reply to personal e-mail
...Appending or Up-dating a formula
I am using an =Ave function in a formula to average quite a few cell values
together. I add new information all the time; sometimes 5 or 6 new cells at
How can I append or up-date my formula to include these new cells with out
have to type the new cells into the formula?
When I make the cell that has the formula in it active/edit, all of the
cells that are referenced in the formula have a highlight around them.
Is there a key or key combination I can press while clicking on the cells I
want to add to the formula?
see your post in Excel.misc
Frank ...formula #59
i am trying to do this::
=IF(J48<25,"",K48) just insert the info from I48 into K48
then add J48 info to I48 and place the total in K48.
is this possible and how is it done
y_not's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19947
View this thread: http://www.excelforum.com/showthread.php?threadid=394739
A formula can only enter values into the cell in which it resides, it cannot
enter data int...Adding a prefix to a cell by using a formula
Is there a formula that I can apply to a specific cell, so that when
it typed into that cell, it will automatically add a set prefix ?
I have a form I designed in Excel that will be emailed to other people. One
of the fields that they need to fill in is an email address. I do not want
this turning into a hyperlink. I know how to disable the hyperlink on the PC
I'm working on , but when the form gets emailed to others, the disable
function is lost. If you type in a " ' " before the email address, it will
not turn into a hyperlink. Is there a way to set...