| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
One last one that I can't figure out how to write a formula for. In B2, the
user will put in a fiscal year, i.e., 2000-2001, 2003-2004, etc. If user puts in, say, 2007-2008 in B2, what formula could be put in C2 so that result would be Sun.Apr.01.2007 (format dependent on the cell's date format, of course). Thank you!  D |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
=DATE(LEFT(B2,4),4,1)
-- Regards, Peo Sjoblom "StargateFanFromWork" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > One last one that I can't figure out how to write a formula for. In B2, > the user will put in a fiscal year, i.e., 2000-2001, 2003-2004, etc. If > user puts in, say, 2007-2008 in B2, what formula could be put in C2 so > that result would be Sun.Apr.01.2007 (format dependent on the cell's date > format, of course). > > Thank you! D> > |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Calender shows at the top eg 01 April - I want Sat 1st April how? | =?Utf-8?B?Tm92aWNl?= | Microsoft Outlook Calendar | 4 | 10th Apr 2006 02:51 PM |
| April CTP | Chhan Rithy | Windows Vista General Discussion | 15 | 27th Mar 2006 02:18 AM |
| April 1 | =?Utf-8?B?YWxhc2thbnJvZ3VlIChNYXJjIEdlb3JnZSk=?= | Microsoft Excel Worksheet Functions | 5 | 8th Apr 2005 05:40 PM |
| Re: Technical Chats Weeks of April 14th & April 21st | Microsoft Access ADP SQL Server | 0 | 23rd Aug 2003 02:42 AM | |
| Re: Technical Chats Weeks of April 14th & April 21st | Microsoft Access | 0 | 23rd Aug 2003 02:42 AM | |
