• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Based on date value in a cell formula for finding day in another corresponding cell.


Dear all,
Good day !!!

supposing i have a1 , a2 , a3 cell contains as date 5th sep 2020 then a4 , a5 , a6 contains date value 6th sep 2020 and so on. i want a formula based on date that gives corresponding day in adjacent another cell.
ex: by formula B1,B2,B3 should gives saturday then B4, B5, B6 gives sunday and so on based on date a1, a2 , a3 etc.

Please assist.



Excel Ninja
Write to cell B1 =a1 and custom format it as dddd >> copy down.
Write to cell B1 =text(a1,"dddd") >> copy down
of course, You could see day with Your A-column too

Peter Bartholomew

Well-Known Member
This doesn't really need a formula, merely a change of number format. To copy the date to another cell is simply
= A1
or, using a defined name 'date',
= date
The number format to be applied to column B is then
To turn this into text one could use
= TEXT(date, "dddd")

Another option is to apply the number format
ddd* d-mmm-yyyy
to the original cell to display day and date in a single cell.