Friday, August 29, 2014
Calculated Fields formulas used in SharePoint
›
Get Week of the year =DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))+0.5-WEEKDAY(DATE(YEAR([Start Time]),MONTH([Start Time...
Tuesday, August 5, 2014
Add a number of months to a date in Excel
›
Many of my friends have query about how to add / Subtract month in excel, Simple way of doing as below =Date( Year ( Start_Date ) + add_...
Thursday, July 3, 2014
Calculate Time in Excel
›
The simple way to calculate the time is sum the two time inputs, shown in below example: Use Excel built-in function SUM to calculate. Us...
Monday, June 16, 2014
How To Get Last Row in Excel VBA code
›
There are many programmatic way to find last row of data input, but the simplest is.... Dim LastRow LastRow = ws.Range("A1")....
Wednesday, May 21, 2014
Creating a file name as a Date stamp in a batch File
›
Source Code line Dir>C:\myFile_%date:/=%.log Output File Name myFile_05212014.log
Friday, April 25, 2014
VBA code for Outlook - Reply Mail With Attachment
›
May times it happens that you want to Reply some mail with attachment but when you click reply, it removes the attachment from your mail, a...
VBA code for Outlook - Forward Mail Without Attachment
›
May times it happens that you want to forward some mail without attachment that you received with attachments, and you need to delete manua...
2 comments:
‹
›
Home
View web version
