ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   please explain (https://www.excelbanter.com/excel-programming/427802-re-please-explain.html)

Dave Peterson

please explain
 
If I'm working with dates, I'll make sure I'm using a date:

dayofweek = weekdayname(weekday(dateserial(2009,4,30)))






sunilpatel wrote:

dayofweek = WeekdayName(Weekday(30 - 04 - 2009))

why is Friday returned not Thursday.


--

Dave Peterson


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com