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.
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.
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.
Subscribe to:
Post Comments (Atom)
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