Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Function (excel 2003)

    I am currently creating a monitoring list, the formula I used in column C is =EDATE(B2,36), this work fine when there is a date in B2, but its doesn't work if any cells in col B is blank as its returm the year 31 Dec 1902 in Col C. How can I fix this?

    In Column E, I used : =IF((TODAY())<(D5+60),"Not Due Yet !!","contact your client!"), Why is the comment show as ' contact your client' when the date is at 31 Dec 1902? How to fix this to just 2 months prior to the expiry date shown in Col C.

    Is there a way to have a date automatically stamp in the Col F after a mail is send for each item under " contact your client"

    Thanks

    cheers, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Function (excel 2003)

    Does the attached do what you want?
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Function (excel 2003)

    Hi Legare,
    Thanks, its does what I want. Is there a way to stamp the date in col F automatically by excel after. let say sending a mail?

    Apprecaite you assistance or any work-around, Thanks

    cheers, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Function (excel 2003)

    If you are using a macro to send the email, then the macro could insert a date in column F. If you are manually sending the email, then you will have to take some action to put the date into the column. The easiest thing to do would be to select the cell where you want the date and then hold down the Ctrl key and press the semicolon ([img]/forums/images/smilies/wink.gif[/img] key. That will put the current date into the active cell.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •