-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
12th
-
D
get the 12th date
not sure if this is possible, but I'm trying to get the 12th day ..but if the 12th day falls on a weekend , I want the tuesday following e.g., this month (July)...July 12th is fine because it falls on a Friday but, for May....the 12th was on a Sunday, so I want the formula to pick up May 14...- daveyc18
- Thread
- 12th date e.g month tuesday
- Replies: 7
- Forum: Excel Questions
-
R
Index Query not working
I have a formula to query every 12th line using the index function. For some reason it is pulling every single line rather than every 12th line? I cannot seem to make the every 12th line work on it? Why does it pull every individual line? =Query(INDEX('Jason Smith'!$C$1:$C,(ROWS('Jason...- Ronderbecke
- Thread
- 12th index line pull query
- Replies: 2
- Forum: Excel Questions
-
Date format error in Power Query
Hi, I have got cleaned and transformed a large data set generated by our server, in Excel 2016 through its "Get & Transform" feature. All was OK and amazing except the error in date format. Server had generated the date as "dd.mm.yyyy" format. The G&T is unable to format date greater than 12th...- Zaigham
- Thread
- 12th date december error format
- Replies: 5
- Forum: Power Tools
