Solution to Custom Date Request
This is solution to request posted at: http://excelexperts.com/custom-date.
Hi,
1. Enter 2 Mar and 8 Mar 2014 into A1 and B1 as dates
2. Format them like: [$-409]Ddd d mmm yyyy"
2. Enter this formula in A2 and fill it down:
=PROPER(TEXT($A$1+7*(ROW()-1),"[$-409]Ddd d mmm yyyy")) &" to " & PROPER(TEXT($B$1+7*(ROW()-1),"[$-409]Ddd d mmm yyyy"))
Example file attached.
Attachment | Size |
---|---|
CustomDate.xlsx | 9.65 KB |
»
- Almir's blog
- Login or register to post comments
- 4438 reads
Recent comments
5 years 45 weeks ago
6 years 31 weeks ago
6 years 43 weeks ago
6 years 46 weeks ago
6 years 47 weeks ago
7 years 6 days ago
7 years 8 weeks ago
7 years 9 weeks ago
7 years 9 weeks ago
7 years 9 weeks ago