Can I change the calendar year beginning date?
Our fiscal year runs July 1 thru June 30 of each year. I need to track
attendance, gas cards, etc for monthly reports. I have a HUGE table with a
gazillion queries and reports for each one. I need one report to reflect
quarterly output for our fiscal year as stated above. Can I make this report
Create a query to use as the source for your report.
In query design, type this into the Field row:
FinYear: DateAdd("m", -6, [InvoiceDate])
replacing InvoiceDate with the name of your date field.
This yields 2007 for all dates in the 2007/2008 financial year...Date Formatting when Concantenating
I have a simple question. I have a cell that has date that looks lik
When I use the concantenate feature my date looks like this:
I tried to format the call every which way - but I cannot get it t
look the original.
Feeling really silly for even asking.. thanks all for your help
Message posted from http://www.ExcelForum.com
="Today is "&TEXT(TODAY(),"mm/dd/yyyy hh:mm")
Norman Harker MVP (Excel)
"bleu808 >" <<bleu808.189yij...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...Show a date 30 days out
I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].
Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later 31
I did =[Sold date]+30 and it did not work
how about dateadd:
dateadd("d", 30, [Sold Date])
"KAnoe" <KAnoe@discussions.microsoft.com> wrote in message
>I have a feild that I would like to show what the date would be in 30 days
> for a feild with a date in it [Sold Date].
...Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From cell 2D). The expire date in "2D" is either the word "none" or a date
that that persons license needs to be renewed.
Those instructors with "None" come out in the calculated field fine, however
the ones with dates come back as whole numbers, Example 8/6/10 shows 40396.
any help will be appreciated
You need to change the format of that cell or column, highlight the cell or
the column, right click o...what is the function and name is of the symbol in each table cell.
Under Paragraph I clicked the Show/Hide Symbol icon so I can now see a
symbol at the end of each text within a table cell.
I wondered what that is so I tried to use Help to find out.
I did find help that mapped a word (like paragraph) into a symbol.
But I can't find anywhere where if I know the symbol it will tell me the
Can you tell me how to find such info?
Or maybe you can tell me what the function and name is of the symbol in each
I'm sorry, I meant to sent this to the Word group.
Of course, I wouldn't mind getting the info...Line Chart with dates in 5 day working week only
Trying to format a chart so that only the 5 working days of the week are
displayed on the x axis. The source data only has the five days (e.g.
05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005
etc etc) So I have missed out the weekend dates.
When I create the line chart however, the weekend dates appear automatically
and just show no point on the chart, therefore there is a longer line between
Fridays and Mondays!!
Hope this makes sense.
Does anyone have any ideas on how to change this? I have tried looking at
Tools-options-chart and cannot seem to turn...need custom cut and paste functions
I once wrote here about a problem I had cutting and pasting where columns
would turn to "REF!" after a cut and paste. I would work around it by
copying, pasting and then manually deleting instead. I thought turning
everything in the sheet to absolute references would solve the problem but
it didn't so now I am thinking of a different solution.
Could someone tell me what I need to do to write my own cut and paste
functions which would basically copy the selection and then on a paste it
would paste and then delete the original selection from where it was copied
from...Function doesn't run
In my spreadsheet, I have the following function
=VLookup(K16, zips, 2)
However, instead of returning a result, the function remains in the
cell. How do I fix this problem?
Format the cell as General and re-enter the formula (F2, ENTER)
Microsoft MVP - Excel
"Justin" <firstname.lastname@example.org> wrote in message news:email@example.com...
| In my spreadsheet, I have the following function
| =VLookup(K16, zips, 2)
| However, instead of returning a result, the function remains in the
| cell. How do I fix th...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...date/time formatting
I download a csv report from a web based program. Everything works great
but the date comes through as "Jul 21 2009 1:51pm". I do not need the time
in my report. I have tried reformatting the cells, tried to copy to a new
file with the cells already formatted to "7/21/09", opening the cell format
using the F2 key and deleting the time (time will still not be formatted
correctly). The only way I get get just the time is to retype every cell.
What am I doing wrong?
I am using Excel 2002 SP3
When data is downloaded from the web, a lot of "other&quo...Adding a button with a function on protected sheets.
How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).
Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the
files is saved, I need to clear that data for use on the next day.
How is this Reset button applied with allowable edit ranges, VLookup data
and a protected worksheet?
There's several ways to do this.
1. Instead of straight vlookups, use
=IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) wher...Today Function
how is this function called in the code?
I want to use in in an update query that is coded to a button.
I hope I'm understanding what your asking for but I think this is what you
are looking for:
>how is this function called in the code?
>I want to use in in an update query that is coded to a button.
Message posted via AccessMonster.com
Well I think it is either
not sure which and not sure how to use it in the code.
I ...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...how can I asign printscreen to a function key or key combination?
My key board has no printscreen key. What can I do?
That seems unlikely, but it is hardly a Word issue. The PrtScn button is
usually a dual function button somewhere on the top row of your keyboard. If
it is not then you need to ask the keyboard manufacturer.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< ...Calculating dates #3
Can anyone tell me what I should use (in the way of helper cells)
to take any date (mm/dd/yyyy) and turn it into that same month
and day for specific year? For instance, turn...
10/12/2009 into 10/12/2010
4/6/1998 into 4/6/2010
I'm trying to determine anniversary date based on start date and
do it starting in 2010.
Assuming your date is in A1.
Hope this helps.
On Jan 5, 5:35=A0pm, Jordon <jordon@REMOVE~THISmyrealbox.com> wrote:
> Can anyone tell me what I should use (in the way of helper cells)
> to tak...how do I format cells to change date and time to just date
I want to format a column that contains date and time and I want it to show
just the date and not the time. Going into format and clicking on the date
and changing doesnt work.
Probably the cells aren't really dates, but text. You can check with the
If they are text, formatting doesn't have any effect.
Microsoft MVP - Excel
"bondam" <email@example.com> wrote in message
>I want to format a column that contains date and time and I want it t...Calculate age as of a date certain
Employee benefit enrollment requires the age of each employee as of a
specific date, such as 1/1/2005. Given the date of birth, how would this be
"Joe S." <JoeS@discussions.microsoft.com> schrieb im Newsbeitrag
> Employee benefit enrollment requires the age of each employee as of a
> specific date, such as 1/1/2005. Given the date of birth, how would
> Joe ...Conditional formatting a date range
If I have a column of dates that are manual entered what is the formula to
conditionally format them based on a date range of three months before the
current date to the current date and another three months after the current
date to the current date?
Assume the dates are in column A, starting with A1. Highlight all the
dates, with A1 as the active cell, and click on Format | Conditional
Formatting. In the dialogue box you should select Formula Is rather
than Cell Value Is and then enter this formula:
Click on the Format button and choose the ...gst/vat caculation problem
Can anybody tell me if the caculation is supposed to be correct, or how to
fix it if it appears not to be working. I have 12.5 entered as gst/vat but
for exapmle I put in 10.00 and it shows an amount of 1.11. Money 2005.
This is the way it has always worked. With A VAT/GST rateof 12.5%, 8.89 is
the amount which would generate the VAT of 1.11 - which sums up to a total
of 10.00, so yes, it's correct
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny or
http://money.mvps.org/faq for UK tips and fixes for MS...Date/Time stamp in Memo Field
Hi all..is it possible to programmatically insert Now() when text in a Memo
field becomes edited?
Thanks for all help!
If it has to be entered directly in the memo field tetxbox:
Private Sub MemoFieldName_AfterUpdate()
If IsNull(Me.MemoFieldName.OldValue) Then
Me.MemoFieldName = Now & " " & Me.MemoFieldName
Me.MemoFieldName = Left(Me.MemoFieldName, Len(Me.MemoFieldName.OldValue)) &
" " & Now & " " & Right(Me.MemoFieldName, Len(Me.MemoFieldName) - Len(Me.
Me.Dirty = False
End...Capturing the ItemID from the Add function.
Can anyone tell me how to capture the ItemID (referenced by the Add function):
Dim objAdded As Object
set objAdded = Session.Transaction.Entries.Add(ItemID, ItemLookUpCode, Qty,
0, False, 0).
I tried the following and am getting an error:
Dim itemid as Long
itemid = Session.Transaction.Entries.Element(entrynumber).Item.ID
The itemID referenced in the add function seems to be the itemID from the
database and not the entry ID on the pos screen.
You can do a query on the Database using the ItemLookupCode.
Use the code I posted a couple of days ago then ...Add Actual End Date to Resolved Cases view
We would like to add the actual end date to the Case General Tab or possibly
to the Resolved Cases and/or My Resolved Cases view. I know that the Actual
End Date is available on the Service Activity and Case Resolution but this
field is not available for the Case.
Any workaround for this?
...due dates #5
thanks alot guys
I have it working now
this will save me a ton of scanning over dates with a visual que
I have 8 pages with 6 rows of due dates on each pag
canman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1459
View this thread: http://www.excelforum.com/showthread.php?threadid=26223
Glad to hear that, canman !
Thanks for the feedback
Please respond in thread
"canman" <canman.1czh20@excelforum-n...Update cell based on date range
Hey guys! I was wondering if I could get some help here. I would lik
to update a cell based on a date range. For example, I would like t
update the value of a cell to the value of another cell if the curren
date is between July 1st and July 10th. However, if the date i
outside the date range, I want the value for that cell to not b
updated, and be the previous value. Can anyone give me an example a
to how I would do this? Thanks!!
deversole's Profile: http://www.excelforum.com/member.php?action=geti...