Re: Date

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Mon, 18 Apr 2005 07:15:02 -0700, "David G" <David
G@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I have a series of dates in column f, and the formula is
>DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)), but I need to check if this date is a
>weekend or weekday. Let us say 06/18/05 is a saturday, I need that cell to
>display 06/20/05, is that possible. Any help you can provide would be
>greatly appreciated.
>
>Thanks in advance

Was there some problem with the responses in .misc?

It would be helpful if you would respond there instead of multi posting.


--ron
.

Relevant Pages

  • Re: Reversing POWER Formula
    ... > (remove nothere from the email address if mailing direct) ... >> Thanks for above responses. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Your smokes, or your job? Unbelievable. The Sheep Look Up
    ... Poetic licence, old bean... ... the same reply to you as to MISC in a different thread... ... Prev by Date: ...
    (alt.smokers.cigars)
  • Re: Question about auto fills or linking sheets
    ... So far this is some great responses and quick too. ... I will have to try it out this friday when my schedule lets up a ... CEN's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25215 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: who would you suggest?
    ... Thanks to everyone for their responses. ... Graham ... Prev by Date: ...
    (uk.telecom.mobile)
  • Re: DIAS.LAB function poblem
    ... Thansk in advance ... See the answer to your question in .misc NG. ... multiple groups. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)