Date Related Problems & Solutions

30 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 30
[Solved] Automating date and time in excel help
Summary: I have a call tracker that I am trying to automate the input of the date and time. My time is not working correctly and my dates are changed for all e...

[Solved] Can you maintain blank rows with a vba auto filter?
Summary: I have a worksheet with data that is automatically filtered when a date is entered in cell I1 via a Worksheet_Change(ByVal Target As Range) macro. Row...

What formula to use to check current or previous owner?
Summary: Hello all I have some data that looks like the following: A B C D E F G 1 ID Name Date bought Date sold Numerator denominator Owner status 2 111 ...

batch file to send an text message
Summary: I have a *.txt file that gets written radomly. I would like to have a batch file that would send a text message when the *.txt message is written to. ...

[Solved] how would I rename a file with date
Summary: Hi, I have a folder with an info file that gets saved daily. However it has the same name each time its saved so everytime it is overwritten. How woul...

Date vs. Creation date
Summary: In Windows 7, there is a wider selection of date attributes, and one of them contains an [b]original[/b] set of the creation date, unlike just the "cr...

[Solved] How do I convert a complex date to a simple date in Excel?!?
Summary: I received a .csv file from a company with a date field that looks like this: Tue Jan 03 12:12:20 PST 2012 I have tried using the Data Type options t...

Finding the time between two different times in excel issue
Summary: As an example I have 2 columns, A and B - both respectively titled Date and Time. In A2 I have: 4/03/2012 In A3 I have: 8/03/2012 In B2 I have: 20:34:...

[Solved] Creating a batch file that makes folders?
Summary: i have a question very similar to this person: http://www.computing.net/answers/wi... In his case he needs hes batch file to create a folder based on ...

append date to osql made backup with batch
Summary: thumbs up for this forum and am glad there's so many volunteers around on line. I'm not familiar with batch, so maybe someone would be so kind to enl...

[Solved] Struggling with Date Formats in Excel 2007
Summary: I have imported data from Peachtree into Excel. My date formats look like 1/1/2010, 2/3/2010 and 3/22/1010. I need to group the data by month. However...

Copy the Date
Summary: I have an SQL generated spreadsheet that returns the dates as 20010719 (Today's date). I was wondering how I can insert the =date() formula into the ...

[Solved] I want to total mileage based on date
Summary: I hae a vehicle mileage log that I track my business miles in. A1 has the date, B1 has the customer name, C1 has beginning mileage, D1 has the ending ...

Changed my Date/Time and Blue Screens
Summary: I'm not sure how I got a virus, as I usually have pretty good internet habits, but I think I must have one. Whenever I try to shut down my computer, i...

Batch to transfer highest numbered folder
Summary: Hi, I have a backup script that backs up files into dated directories, for example 20110322, one for each day, so I have backups from different days. ...

Batch Moving Files in Folder of FileDate-Part
Summary: Hi all, I have a lot of Files in an Folder. These Files should be moved in an new Folder with the Month and Year of the File. For example: 23.09.2009 ...

Batchscrip to zip files by date and del files
Summary: Hi, I'm trying to figure out how I can make a script that does 3 things ( or 4 depends on how it's done ). I have a folder with a lot of log files tha...

part number changes to date
Summary: We have part numbers for decals DEC-1 and DEC-12 and are linking into InDesign via Easy Catalog Creator which uses a .csv file for updates, but every ...

Date disappeared form clock in system tray!?
Summary: Turned on the computer today and no date. I did nothing to my computer recently but all of a sudden the "date" portion of the clock is gone! I went i...

Copy Multiple Selection by Date Range
Summary: I'm trying to create a macro that will copy multiple selections from a sheet in one workbook to another sheet in another workbook. The selection would...

how can i copy data on a certain date in exce
Summary: How can I set up a formula to copy data from one worksheet into another cell of another worksheet in the same workbook on a certain date? I can figur...

Stop the automatic update of a date column
Summary: I am using excel to develop a stock management sheet. The worksheet (called Action Sheet) is laid out with code(A), name(B), date(C), action(D), user(...

Excel Date Calculations
Summary: I am trying to calculate the number of days in each specific fiscal year from the new release date up to but not surpassing the original release date....

Crazy windows xp clock
Summary: It's many time that in my windows xp my clock is crazy. It shows the date of about one month before and also the hour is not correct. If I correct dat...

Current date/time in a variable (solved)
Summary: This is solving for place current date or time to environment variable. It works under all windows versions. One (but important) restriction - you nee...

Excel IF statement for 9-5
Summary: I am trying to build a report which shows if a date and time is between 9-5 Column 5 has a date/time value of 04/01/2010 13:36:00, I need to output th...

Complicated Excel Formula
Summary: This might not be very complicated for the Excel Gurus out there, but I have run out of ideas. I have an Excel spreadsheet with the following informat...

IF statement. Dates with different outcomes
Summary: I am trying to extract some data on dates to a dashboard to present it in a pie chart. I have a list of dates relating to when something was tested. ...

Subtotal Date Ranges
Summary: Hello, I'm working on an attendance report in Excel, trying to automate a way to count the number of absence occurrences. For example, if an employee ...

Batch witch starts a command with parameters.
Summary: Hi. I need batch, which: 1) starts a command with parameters: D:\install\trim.ovpl -u user -p pass -date %DATE%T18:00:00 -name Node where in place...

1


Ask Question