Hello.

I have a situation where I need to calculate a date out three years from a
given start date. For example, I have a date, say 6/8/2005, and I want to
know what the three year anniversay date is from this date, to inlcude
compensating for leap years. I have played with the date functions and tried
to formulate a formula to solve this, but to no avail. Any ideas would be
helpful.

Thank you.

NWO.

with your date in A1

=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))


--

Regards,

Peo Sjoblom

"NWO" wrote in message
...
Hello.

I have a situation where I need to calculate a date out three years from a
given start date. For example, I have a date, say 6/8/2005, and I want to
know what the three year anniversay date is from this date, to inlcude
compensating for leap years. I have played with the date functions and
tried
to formulate a formula to solve this, but to no avail. Any ideas would be
helpful.

Thank you.

NWO.

Thank you Peo.

NWO :)
----------------

"Peo Sjoblom" wrote:

with your date in A1

=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))


--

Regards,

Peo Sjoblom

"NWO" wrote in message
...
Hello.

I have a situation where I need to calculate a date out three years from a
given start date. For example, I have a date, say 6/8/2005, and I want to
know what the three year anniversay date is from this date, to inlcude
compensating for leap years. I have played with the date functions and
tried
to formulate a formula to solve this, but to no avail. Any ideas would be
helpful.

Thank you.

NWO.

I need help; I have a date in column B, the formula in Column C is
=b5-14, this returns another date.

If that day falls on a Saturday or Sunday, I'd like the returned value
to be the previous Friday.

I can't figure out how to do this.

Can you help?


--
Sherry Moss
------------------------------------------------------------------------
Sherry Moss's Profile: http://www.excelforum.com/member.php...o&userid=29535
View this thread: http://www.excelforum.com/showthread...hreadid=492334

=B5-14-(WEEKDAY(B5,2)5)-(WEEKDAY(B5)=1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sherry Moss"
wrote in message
...

I need help; I have a date in column B, the formula in Column C is
=b5-14, this returns another date.

If that day falls on a Saturday or Sunday, I'd like the returned value
to be the previous Friday.

I can't figure out how to do this.

Can you help?


--
Sherry Moss
------------------------------------------------------------------------
Sherry Moss's Profile:
http://www.excelforum.com/member.php...o&userid=29535
View this thread: http://www.excelforum.com/showthread...hreadid=492334

Thanks, Bob. This will save me load of time.:)


--
Sherry Moss
------------------------------------------------------------------------
Sherry Moss's Profile: http://www.excelforum.com/member.php...o&userid=29535
View this thread: http://www.excelforum.com/showthread...hreadid=492334