How do you get a "Day" from a "Date"

Reply #11

KnuckleHead — Thu, 07 May 2009 16:12:58 GMT

Morning time*treat

No problem, when I first started using a computer, Excel didn't do what I wanted, so since Lotus was pre-loaded, that's all I've ever used. I understand that different things in Excel and Lotus123 can be crossed over and still work. I've even used some examples that I've found for Excel in Lotus. I've just never thought of switching over...so if some of my questions seem odd, no you'll understand why.

Thank you for the intrest.

Reply #10

time*treat — Thu, 07 May 2009 15:15:55 GMT

I missed your mention of Lotus, in the OP. I confess to not knowing Lotus1-2-3 was still around.

Reply #9

Raven62 — Thu, 07 May 2009 11:59:28 GMT

Hi KnuckleHead,

Glad I was able to help: Not too many folks using Lotus 123 these days: It'll do pretty much anything you want to do with a Spreadsheet!

Good Luck,

As long as you have a willingness to learn you'll do fine

Reply #8

KnuckleHead — Wed, 06 May 2009 14:55:53 GMT

Helo Raven62,

Now I'm gald I posted my formula. It took me quite a while to figure out... That being said, all of you have posted other ways to do the same thing in an easier format. Glad I found this site...I'm more of a computer novice and do not have to experience needed to create what I think of doing.

Thank all of you for the help and suggestions.

Reply #7

Raven62 — Wed, 06 May 2009 14:46:21 GMT

Cell A2=01/01/2009 or the Date Format you Promote to the (Range Properties) Frequently Used List (2009/01/01)

Cell B2=@DATEINFO(@DATEVALUE($A2),1

Reply #6

KnuckleHead — Wed, 06 May 2009 12:20:17 GMT

Thank you Coin Toss,

I didn't know that the calendar was there. That could be very useful. There's quite a lot on the web if you think about what to look for. I just didn't think to look for it.

Ppreaciate it.

Reply #5

Coin Toss — Wed, 06 May 2009 03:39:06 GMT

Not Excel (well maybe the site is using Excel) but here's another way:

http://www.timeanddate.com/calendar

Reply #4

KnuckleHead — Wed, 06 May 2009 02:04:57 GMT

Thanks time*treat,

I tried your suggestion, but it doesn't work in my version of Lotus123, so I needed something like I described.

My thought was that someone else migt have run into the same problem and this would be a work around to help in building their histories .

Thank you for the suggestion though, I didn't know that you could do that in Excel.

Reply #3

time*treat — Wed, 29 Apr 2009 21:00:34 GMT

(highlight all the cells you want to use) -- Format -- Cells -- Number -- Custom -- (in the type field, put) -- ddd (or) dddd -- [ENTER

Reply #2

KnuckleHead — Wed, 29 Apr 2009 20:06:38 GMT

Because I hadn't found it...

Reply #1

time*treat — Wed, 29 Apr 2009 19:08:57 GMT

Why not just use the built-in format for this

How do you get a "Day" from a "Date"

KnuckleHead — Wed, 29 Apr 2009 18:59:04 GMT

Hi all,

If your working on creating a histories file and you want to figure out what day of the week a Date is, try this:

@IF(@CELL( type ,B80..B80)= b , ?? ,@IF(@WEEKDAY(B80)=0, Mon ,@IF(@WEEKDAY(B80)=1, Tue ,@IF(@WEEKDAY(B80)=2, Wed ,@IF(@WEEKDAY(B80)=3, Thu ,@IF(@WEEKDAY(B80)=4, Fri ,@IF(@WEEKDAY(B80)=5, Sat ,@IF(@WEEKDAY(B80)=6, Sun , N/A ))))))))

The B80 refers to the cell that has a date (ie: 4/2/2009) in it. This formula can be set into the next cell so that as you enter your his... [ More ]