Hi Swanav,

Say your date is in A1 then in B1 put =WEEKDAY(A1)
This will return a number from 1 to 7, 1 being Sunday
and 7 being Saturday.

If you want it to show the actual day then format B1 as
custom dddd

There are a few other options that you will find in the help file.

HTH
Martin