| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill in Date problem
Good to see, and thanks for the response, but check that you picked up the amendment to the original post. The formula for A3 should refer back mainly to A2, with one reference to A1 (replacing the reference to H0 in formula for A2) -- Lisa Wrote: "Bryan Hessey" wrote in message ... in the 5th week (A5) =IF(MONTH(A4+7)=MONTH(A4),A4+7,"") in the next first week =IF(A5="",A4+7,A5+7) Hope this helps That's fabulous, Thanks!! I was nearly there - just hadn't worked out the MONTH bit. Lisa -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=535305 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing csv files, problem with date formats | Excel Worksheet Functions | |||
| Date Format problem | Excel Discussion (Misc queries) | |||
| Leap year date problem | Excel Worksheet Functions | |||
| problem in date time picker size | Excel Discussion (Misc queries) | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Threaded Mode
