If function with dates
Closed
kevinlewis13
Posts
2
Registration date
Saturday October 5, 2013
Status
Member
Last seen
October 6, 2013
-
Oct 5, 2013 at 10:00 PM
kevinlewis13 Posts 2 Registration date Saturday October 5, 2013 Status Member Last seen October 6, 2013 - Oct 6, 2013 at 01:13 PM
kevinlewis13 Posts 2 Registration date Saturday October 5, 2013 Status Member Last seen October 6, 2013 - Oct 6, 2013 at 01:13 PM
Related:
- If function with dates
- Agp function - Guide
- Network card function - Guide
- Find function on mac - Guide
- Function of insert key - Guide
- Accessor function c++ - Guide
2 responses
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Oct 6, 2013 at 06:40 AM
Oct 6, 2013 at 06:40 AM
Hi kevinlewis13
Two ways and assuming the dates start in C2. For example if the date in C2 = "27/12/2013".
This will return "Week4 ":
="Week"&CEILING(DAY(C2)/7,1)
and copy down.
Or if you require: "Dec: Week4":
=TEXT(C2,"mmm")&": "&"Week"&CEILING(DAY(C2)/7,1)
and copy down.
Kevin
Two ways and assuming the dates start in C2. For example if the date in C2 = "27/12/2013".
This will return "Week4 ":
="Week"&CEILING(DAY(C2)/7,1)
and copy down.
Or if you require: "Dec: Week4":
=TEXT(C2,"mmm")&": "&"Week"&CEILING(DAY(C2)/7,1)
and copy down.
Kevin
kevinlewis13
Posts
2
Registration date
Saturday October 5, 2013
Status
Member
Last seen
October 6, 2013
Oct 6, 2013 at 01:13 PM
Oct 6, 2013 at 01:13 PM
Works like a dream! Thank you so much!
