PC Review


Reply
 
 
StargateFanFromWork
Guest
Posts: n/a
 
      29th May 2007
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


 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      29th May 2007
=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
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:45 PM.