S
StargateFanFromWork
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
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