Today Day And Date
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 160150 articles for 2.521 sec
A1: the nominated month as text, say May C1: =DATEVALUE("01-"&A1&"-"&YEAR(TODAY())) C2: =IF(OR(C1="",MONTH(C1+1)<>MONTH(C1)),"",C1+1) and copy C2 down -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ajit Munj" <ajitmunj@microsoft.com> wrote in message news:EAA4AC28-30C1-4859-8EAF-0C1B2C10C810@microsoft.com... >I want excel to     

Group: microsoft.public.excel.misc · Group Profile · Search for Today Day And Date in microsoft.public.excel.misc
Author: Bob Phillips
Date: Dec 10, 2007 00:54

Can you use a brute-force method? Just split the operations up into smaller chunks. In Column E put in a formula like: IF(OR(D1>date1),(D1<date2)),SUM(B1,C1),0). In column F put in something like: IF(D1=date3,C1/(TODAY()-date3),0). Then copy alongside all of the rows with data and sum columns E and F. Somewhere off to the side define three cells as date1, date2, and date3 and put in
Show full article (0.54Kb)
assuming in your example and formula column T is B Column U is B and Column yY is d try =SUM( ('2-19-07'!$T$3:$Y$64000 )+sumproduct(--(('2-19-07'!$Y$3:$Y$664000>date(date1),--('2-19-07'!$Y$3:$Y$64000<date(date 2),'2-19-07'!$U$3:$U$64000)+sumproduct(--(('2-19-07'!$Y$3:$Y$64000>date(date3),'2-19-07'!$U$3:$U$64000/(days360(TODAY(),'2-19-07'!$Y$3:y64000)) I think Date3 is 'Overall Completion'     

Group: microsoft.public.excel.misc · Group Profile · Search for Today Day And Date in microsoft.public.excel.misc
Author: Tom Hayakawa
Date: Mar 6, 2007 13:08

Given this table A B C D 1 1717 1697 20 3/15/07 2 934 839 95 3/30/07 3 853 594 259 2/23/07 I need the sum of B and C (adding C only if D is between 2 dates) plus for dates in D a certain date (2/26/07) take C divided by # of days between today and that date in D. I need 1 lump sum. I have a formula that works, but I do not
Show full article (1.36Kb) · Show article thread
This is a very useful thread, but what if you only want the current date to be put in when you click on the cell "Gord Dibben" wrote: > Format the cell to whatever you want to see. > > Cells>Format>Number>Date or Custom > > Or use =TODAY() > > > Gord Dibben Excel MVP > > > > On Fri, 18 Nov 2005 08:28:48 -0800, "Andy JL" > <AndyJL@discussions.microsoft.com> wrote: > >     

Group: microsoft.public.excel.misc · Group Profile · Search for Today Day And Date in microsoft.public.excel.misc
Author: bj
Date: Mar 6, 2007 13:06

Is it possible to write a query, when i mention week1 in column DAY, the query should calculate from today's() date and if its 1stweek of the current month it should throw today's date. same way if i type week2 in column DAY, the query should calculate from today's() date and if its 2ndweek of the current month it should throw today's date.. "Allen Browne" wrote: I'm not exactly
Show full article (1.48Kb) · Show article thread
I'm not exactly sure how you are calculating this, but this expression should give you a value from 1 to 5 for the week of the month of today, assuming week 1 starts on whatever day of the month if falls: (Day(Date()) - 1 \ 4) + 1 -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne     

Group: microsoft.public.excel.misc · Group Profile · Search for Today Day And Date in microsoft.public.excel.misc
Author: JL InRe
Date: Mar 6, 2007 12:24

actually my requirement is a Task Tracker, my query should view me all the reports pending for that particular day, i have daily, weekly, monthly, quertly reports, only onces in a year all the reports name and frequency(daily, weekly, monthly, quertly) will be entered in a table, the dates will not be in same day(tue, wed....) for every month, so i can't give the exact date for each reports
Show full article (0.82Kb)
Can I suggest an alternative structure here? Try a table with fields like this: - TheReport Text name of the report to run. - FirstDue Date/Time the day it is first due. - Freq Number - PeriodID Text For the PeriodID you will use a combo, with a list of valid entries that can be used with DateAdd(), so "d", "ww", "m", "q", or "yyyy"     

Group: microsoft.public.excel.newusers · Group Profile · Search for Today Day And Date in microsoft.public.excel.newusers
Author: fomula problems
Date: Sep 15, 2008 02:15

i need a query to view the dates and report names example: There are Three columns(Frequency, DAY, REPORT)in a TABLE, now my query should give me the date as shown below in QUERY, only if the report is due today(example:Fri) Explanation of a TABLE Daily: my query should show the reports(a,b,c,d) every day, if i have mentioned Daily in ‘DAY’ column. Weekly: my query should show the
Show full article (0.83Kb)
    

Group: microsoft.public.access.queries · Group Profile · Search for Today Day And Date in microsoft.public.access.queries
Author: Ranjit kurian
Date: Sep 13, 2008 03:43

Show full article (1.99Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Today Day And Date in microsoft.public.access.queries
Author: Allen Browne
Date: Sep 12, 2008 23:39

Show full article (1.52Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Today Day And Date in microsoft.public.access.queries
Author: Ranjit kurian
Date: Sep 12, 2008 23:34

Show full article (4.27Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Today Day And Date in microsoft.public.access.queries
Author: Allen Browne
Date: Sep 12, 2008 19:43

Show full article (3.17Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Today Day And Date in microsoft.public.access.queries
Author: Ranjit kurian
Date: Sep 12, 2008 11:07

Show full article (0.93Kb)
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next