| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weeks and dates
I solved it by using the date instead and using the following: =IF((TEXT(C2,"mmm"))=(TEXT(C2+6,"mmm")),(TEXT(C2," mmm")),CONCATENATE((TEXT(C2,"mmm")),"/",(TEXT(C2+6,"mmm")))) /Møller -- c991257 ------------------------------------------------------------------------ c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549 View this thread: http://www.excelforum.com/showthread...hreadid=563706 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting dates into weeks... | Excel Discussion (Misc queries) | |||
| Function to calculate the nuber of weeks between dates? | Excel Worksheet Functions | |||
| WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES | Excel Worksheet Functions | |||
| Weeks between dates | Excel Worksheet Functions | |||
| Calculating number of weeks from two dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
