ExcelBanter

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

sunilpatel
please explain
 
dayofweek = WeekdayName(Weekday(30 - 04 - 2009))

why is Friday returned not Thursday.



GS
please explain
 
Dates don't have spaces. Entering it as 30-4-2009 returns Thu.

HTH
Garry

"sunilpatel" wrote:

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

why is Friday returned not Thursday.





All times are GMT +1. The time now is 04:07 PM.

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