Formular to calculate DATE

  • Thread starter Thread starter Eileen
  • Start date Start date
E

Eileen

Given a date, is there a way/formular that I can
determine the date of the week in another column for
further analysis? For example, A1=7/10/04, I need to have
a formular to show B1=Saturday.

Thanks for help.
 
in B1 put

=A1

do format>cells>number custom and use dddd

or if you want a text representation

=TEXT(A1,"dddd")

personally I'll probably go for the latter since you by
any chance format B1 to anything else General it will return a number

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
weekday function will give you 1-7 for the days of the week (use a llokup
table to give you the proper day ie Monday etc
 
Given a date, is there a way/formular that I can
determine the date of the week in another column for
further analysis? For example, A1=7/10/04, I need to have
a formular to show B1=Saturday.
Click to expand...

How about:

=TEXT(A1,"Dddd")
 
Hi Eileen.............

Put this in B1

=TEXT(WEEKDAY(A1),"dddd")

Vaya con Dios,
Chuck, CABGx3
 
at destination column put formula =Text(a1,"dddd") for
full day and =text(a1,"ddd") for abbrviated day

poonia
 
That definately help! Thanks ! Further question, is there
an easy way that I can align the dates during the week to
that Monday? For example, a1=7/11/04, the result of
B1=7/5/04.
 
When using the TEXT function, you might want to try usin
=TEXT(A1,"[$-409]dddd") to ensure English formatting. (I am assumin
this works on all local versions
 
in order to get a date of one week from today:

=DATE(YEAR(TODAY()),MONTH(TODAY()),(DAY(TODAY())+7)).

in the DAY section, add 7 or subtract 7 depending on whether the dat
needs to be one week hence, or one week ago
 
ron,

:-), that was pretty much duh! on my part.

kicking myself for having missed that... thanks from bringing me bac
to simplicity.

mac
 
Back
Top