+ Reply to Thread
Results 1 to 3 of 3

Date and Time issues

  1. #1
    Registered User
    Join Date
    12-01-2010
    Location
    Tallinn
    MS-Off Ver
    Excel 2010
    Posts
    16

    Date and Time issues

    Greetings all, some Excel issues that my noggin cant handle...

    I have a date (totally random 12.12.12 for example), and I have a value "k" (any number, like 7 for example).
    Ive been tasked with some things that I cant quite figure out what to do:
    1) First, I need to figure out the original dates next months day which is "k". I figure something along the line of adding a month and the value of k to the original date. But how do I add months specifically ? If I even grasped the idea correctly.
    2) I now need to give the newly made date in point one the day name. the function: =IF(WEEKDAY(C11)=1;"Monday";IF(WEEKDAY(C11)=2;"Tuesday";IF(WEEKDAY(C11)=3;"Wednesday";IF(WEEKDAY(C11)=4;"Thursday";IF(WEEKDAY(C11)=5;"Friday";IF(WEEKDAY(C11)=6;"Saturday";IF(WEEKDAY(C11)=7;"Sunday"))))))) Wont do, I need to take the dates from a list, with 1 being Monday, 2 being Tuesday and so forth. The first function doesnt work because it appears to take the day name from a calendar from somewhere. As in lets say day 2 on list is Tuesday, but with that function above it could be any date from the calendar. Also, how can I make sure that in the list day 8 is Monday, day 22 is Tuesday...
    3) I am also required to substract days from one date from another. Like 21.05.2080 minus 20.02.2014 equals ? in days... and just out of my own curiosity, how could I extract months... This shouldnt be too hard, but I still managed to screw up It gave me the value in some random date 19.05.1900...

    Thank you for taking your time to read this and perhaps even possibly replying with a few helpful tips.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Date and Time issues

    You will find answers for your homework at this site

  3. #3
    Registered User
    Join Date
    12-01-2010
    Location
    Tallinn
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Date and Time issues

    Alright got most of em fixed, except for number two. I cant seem to figure out a way to take the date name from the list, with 1 being Monday and 2 Tuesday,28 being Monday again regardless if it matches the calendar dates. =TEXT(C11;"dddd")&"; "&TEXT(C11;"mmmm")&" "&TEXT(C11;"d") Wont do, it takes the date from the actual calendar -.- I figure there is a way to make it take the date names from the table, but it would require 31 IF formulas... is there a way to make it shorter ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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