You are here: HomeExcelTutorials

formulas based on a date

formulas based on a date

Price: FREE

In cell A1, I have a date, say, May 10, 2003
In cell B1, I want to input a formula so that it returns the first of the following month, in this case June 1, 2003
If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003

Visit publisher's web-site: formulas based on a date

Category and Tags: ExcelTutorials : : Functions

Related Tutorials

sum formulas based on date

Free: Yes
Tags: Excel › Functions

How do I create a formula that will sum up a row based upon a particular date?

date formulas

Free: Yes
Tags: Excel ›

I have two problems that need help.
Cell A1 has a date of birth. Cell A2 calculates the age. If there isn't a
dob of birth, cell A2 returns 110.
Another one is having cell C1 with a date or NA. C2 is based on cell C1 and
adds 3 months to the date in C1 but if C1 has NA, the return is #value!.

Tables and Dynamic Formulas

Free: Yes
Tags: Excel ›

I have a table of data and want to perform analysis on the data table in different scenarios. Say I have a date column and narrow down the table by selecting a specific date range, then I would want to have my formulas only analyze the shown data. When I've been attempting it currently, after narrowing down the date range, my formulas are still calculating based upon the hidden and unhidden data in the table. I am using excel 2008.

Actions by date

Free: Yes
Tags: Excel ›

Does anyone know how I can program Excel, using VBA-code, to let it calculate certain formulas based upon predetermined dates.
F.e. : A certain amount needs to be capitalized from date A till B. Between A en B it's possible that there are some movements on the capital, like withdrawals, monthly costs, etc.
To visualize this :
In sheet 1 : let's put all the info : the amount, the interest, start_date, end _date, withdrawal of. (amount)on the.(date, between start and end) and every first of the month between the start and and date an administrative cost for the capitalisation contract of 1.
In sheet 2 : the formulas needed to calculate the capitalization
In sheet 3 : the output : Excel takes the start_date and copies the formulas in the logic order based upon the dates on which a certain calculation needs to be made.
Has anyone have any ideas how to code this.

Excel, date-sensitive, 2-part formulas

Free: Yes
Tags: Excel › Functions

I am trying to figure out a formula for billing in Excel 2003.
I want to be able to enter # of pents based on date.
So far I have:
=if(b2>39217,3,2)
meaning: if date (b2) is greater than 5/14/07, 3 payments, otherwise2. BUT I also want to say: AND if the dates in B2 are less than 5/1/05, 1 pent.

Related Applications & Scripts

dhtmlxCalendar - Ajax DatePicker

Free: Yes
Tags: Ajax › Excel Calendars Forms

dhtmlxCalendar is a lightweight cross-browser JavaScript calendar which can be configured as a popup date picker or a flat calendar. The component is easy-to-use and fully customizable. It can be attached to any text input field and provides fast and intuitive date selection in web-based applications.

Date icon component

Free: No

This is a simple component that can be added to an application showing the current date (or a selected date).
It is easily skinnable using flex css styles.

Date Picker

Free: Yes
Tags: Ajax › Excel Date and Time

This element enables you to pick dates with a simple slider bar. By dragging the bar over the time-line, the dates change instantly. Besides this, when the user decides to manually change the dates, the bar is automatically adjusted to the corresponding dates. As you are used to from us, the script is based on Prototype/Scriptaculous, but now combined with the DateJs library.

Micro Guestbook

Free: Yes
Tags: PHP › Excel Guestbooks

Micro guestbook is a free MySQL based guestbook script with a CSS based attractive interface. It can store the name, date, message, location, web and email information of the visitor.

Date Picker as3

Free: No
Tags: Flash › Excel Date and Time