Results 1 to 7 of 7

increment date by one day

Threaded View

emilis increment date by one day 07-17-2008, 03:04 PM
Ron Coderre increment date by one day 07-17-2008, 03:20 PM
emilis wow... i'm just learning... 07-18-2008, 01:26 PM
EAMOG Hi was just looking through... 07-19-2008, 07:55 PM
Ron Coderre Explanation for: E11:... 07-19-2008, 08:27 PM
emilis Hi, Ron - I'm seeing this... 07-22-2008, 06:43 PM
Ron Coderre =+Ref vs =Ref 07-22-2008, 07:25 PM
  1. #1
    Registered User
    Join Date
    07-17-2008
    Location
    California
    Posts
    11

    increment date by one day

    Hello,

    I'm trying to show a date in MM/DD format going across five cells that represent the days of the week. I want to calculate the correct date after entering a start date. For example:

    I would modify the formula in cell B6 using the DATEVALUE formula by typing in a specific start date, such as:=DATEVALUE("6/30/2008")

    I would then like cells E11:I11 to show:

    E11: Mon,6/30
    F11: Tues,7/1
    G11: Wed,7/2
    H11: Thurs,7/3
    I11: Fri,7/4

    I chose to use the DATEVALUE function because I read that it's easier to add dates when converted into their serial number equivalent. I would also like to do this without VBA, if possible. If I'm attempting this all wrong, feel free to point me to the right direction.

    Appreciate the help!

    Emil
    Last edited by VBA Noob; 07-17-2008 at 03:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1