Consolidate / Merge all your PF accounts

Hi friends,

Today, I have come across one useful website which consolidates all your PF accounts under one roof.

Pre-requisite

1. You should have one active and current PF account
2. You should have UAN created and activated
3. You should have your old PF account numbers

Important Information

If you have changed organization, then wait till the previous employer update your "Date of Exit (DoE)"
After that your current employer details should be available
To verify that, please login to your UAN services account
https://unifiedportal-mem.epfindia.gov.in/memberinterface/
Go to "View" -> "Service History"
You should be able to see your present and previous employers
Note: You wait for atleast 3 months, after you exit from your previous organization

Procedure

1. Visit http://oeoea.epfoservices.com/UANDEDUP/index.jsp site
2. Enter your registered mobile number
3. Enter your UAN number
4. Enter your current active PF account
5. Once you login, you should be able to view your all registered and linked PF accounts
6. Consolidate all PF accounts by selecting and further processing

Please send your comments and feedback to psrdotcom@gmail.com

Change Google + (Plus) details like Date, Description, Location

Hi Friends,

This post related to the change of Google Plus album details like data, description, location etc.

 

Problem

I have got a situation like, after my album photos upload. My latest album was not in the first position in album list.

When I just opened the album, it was showing some old date and I was not able to edit the date of the album.

The current Google + settings once you have uploaded the album.

 

Objective

Update date of your Google + album

 

Resolution Procedure

Please click on this link to redirect to Picasa web albums

https://picasaweb.google.com/lh/myphotos?noredirect=1

Now you can see all your albums

Click on the album which you want to change the album details

Change the “Date” or any other field of your choice

Save it

That’s it. You are done.

Now you can view the updated album list your Google + Albums

 

Please write your queries and comments @ http://psrtechtips.com/contact

 

Blogger Labels: Change,Google,Plus,Date,Description,Location,Friends,album,data,situation,Objective,Update,Procedure,Click,Save,comments,photos,albums

Finding Date Difference in Excel and by using Macro

Date Difference in Excel

We can use Days360 function to find the days difference

Syntax: 
=days360(startdate, enddate, true)

Example:

A1	B1	C1
3/20/2010	3/26/2010

Type the any one of the following in C1 

To find the days difference, use
 =days360(A1,B1,True)
=B1-A1


To find months difference, use Month(B1)-Month(A1)


To find years difference, use Year(B1)-Year(A1)

Then the sheet A1 and B1 contains the following values with the Date format

A1	B1	C1
3/20/2010	3/26/2010	6

Note: It will return integer value so don't format the resultant(C1) cell to Date.

Date difference by using macro

We can use the datediff function to find the days, months, years difference between two dates

Syntax:
Cell.Value = datediff(interval, Range("startdate_cell").Value, Range("enddate_cell).Value)

Note:
interval can be any one of the following
d - days, m - months, y - years, ym - months excluding years, yd - days excluding years, md - days excluding years and months

Example:
Range("C1").Value = datediff("d", Range("A1").Value, Range("B1").Value)

References:
 http://office.microsoft.com/en-au/excel-help/calculate-the-difference-between-two-dates-HP010070467.aspx

http://www.cpearson.com/excel/datedif.aspx