Not exactly,
If my formula returns a date that falls on a Sat or Sun, I would like it
to advance to the Mon after the weekend (when I would be at work).
...Lisa
Andrew Jensen wrote:
You mean as in - create a date that is the first Monday of last month?
On 9/30/07, Lisa Hetherington <[EMAIL PROTECTED]> wrote:
Perfect Andrew!!
Is there a way to modify the formula to return only weekdays (Mon-Fri)
...Lisa
PS I usually see bottom posting here, I just continued top posting to
not confuse things.
Andrew Jensen wrote:
Hi Lisa
Qutoe:
"Since months and years do not have regular count of days you need
DATE as a helper:
Same day, next month: =DATE(YEAR(A1);MONTH(A1)+1;DAY(A1))
Contrary to the lousy documentation, DATE can calculate dates by
positive, negative and zero arguments. It knows about leap years and
count of days.
Last day of this month is zeroth day of next month:
=DATE(YEAR(TODAY());MONTH(TODAY())+1;0) "
The actual post can be found at
http://www.oooforum.org/forum/viewtopic.phtml?p=235456#235456
Drew
On 9/30/07, Lisa Hetherington <[EMAIL PROTECTED]> wrote:
Adrian Try wrote:
Hi Lisa
I would like one cell to return an addition or subtraction of months
or years from the date in another call. (whatever the need is)
Have a look at the months and years functions.
This is from the online help:
MONTHS
Calculates the difference in months between two dates.
Syntax
MONTHS(Start date, End date, Type)
Start date: First date
End date: Second date
Type: Calculates the type of difference. Possible values include 0
(interval) and 1 (in calendar months).
YEARS
Calculates the difference in years between two dates.
Syntax
YEARS(Start date, End date, Type)
Start date: First date
End date: Second date
Type: Calculates the type of difference. Possible values are 0
(interval) and 1 (in calendar years).
Hope this helps.
Adrian
www.tryanotherangle.org
Thanks Adrian...that is not quite what I wanted to do.
I have the difference and one date. I do not have two dates to
calculate the difference of. I would like to calculate the 2nd date.
I have a date in A1 (Oct 18, 2007) and I know I can enter
=A1+2 and that returns a date of Oct 20, 2007
=A1-36 returns a date of Sept 12, 2007
That works for days.
How do I have Calc add or subtract months or years....
...Lisa
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
