Formulas

G

Greg1961

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm new to excel and have a question about a formula. How do you make a formula for Dates that will always take it to the end of the month. For example, one of the fields is the date that a task was accomplished for example 1/20 /09 and it's due again 3 months later only it's always due at the end of the month 4/30/09. Is this possible, If so whats the formula??
Thanks.
 
C

CyberTaz

One option: Use the EOMONTH function. If the Jan date from your example is
in cell A10 & you want the projected date in F20 use the formula:

=EOMONTH(A10,3)

And format F20 for whatever date formatting you prefer.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in Chart Titles Axis Titles 4
Local Date Format in Excel 1
Formula bar is too long - Can it be automatically shortened? 4
subtraction formula 4
Using input for formula and displaying result 1
compatibility error with dates between excel2008 and windows excel 2007 3
function for array 1
Excel formula; all negative values return with 0 2

Top