April 11, 2010

Find day of a Date:

If you would like to find the day of a given date we can find it very easily, please look into the below example and formula,





In the above example, we have a date in cell A1 and we did find the day of that date on which it occurred. We used text function to find it, the formula convetedthe format of the date as “ddddddd”, then we got the day of the given date.

1 comment:

  1. Awesome article…..truly appreciated. We have an amazing tool, You can try this out Find and Replace in Excel tool which help you to find and replace multiple words in multiples excel files . Thanks

    ReplyDelete