Dear Team,
I am trying to use below code to send mails from Excel 2010 to Lotus note ,
I am getting below error , please help to solve the issue
___*
__
*
* "-
Dear R.Karunanithi
Thank you very much for providing very descriptive information. Now I have
solved my issue.
On Monday, November 26, 2012 4:18:51 PM UTC+5, MRafique Ujjan wrote:
>
> Dear All Excel Experts:
>
> I am having a following problem.
>
> I am given only total working days of an empl
Dear Neeraj,
If you are using Excel 2007 or above
1. For random dates use :-
*=DATE(2012,RANDBETWEEN(1,12),RANDBETWEEN(0,31))*
2. For random time Eugene Bernard's solution will work perfectly
Hope that helps,
Anand Kumar
On Saturday, 1 December 2012 10:48:04 UTC+5:30, neeraj chauhan wrote:
>
>
Dear Hemant,
1. In your second column you can use EOMONTH() to find the last date of the
month. Instead of the long function you are using. (Useable with version
2007)
2. As you have 3 different cases for finding due date you should use 3
different columns.
3. I have used the following function
Dear Hemant,
1. In your second column you can use EOMONTH() to find the last date of the
month. Instead of the long function you are using. (Useable with version
2007)
2. As you have 3 different cases for finding due date you should use 3
different columns.
3. I have used the following function
