B
Bret
I want to convert the dates of tasks to the fiscal year they were completed.
The fiscal year we operate under is July 1 to June 30. In my spreadsheet the
Date Completed is column G and shows for example 6/16/2007 and I want a new
column to reflect just the fiscal year which would be FY07 in this case. A
completed date of 8/15/2007 would be FY08. Appreciate any help.
The fiscal year we operate under is July 1 to June 30. In my spreadsheet the
Date Completed is column G and shows for example 6/16/2007 and I want a new
column to reflect just the fiscal year which would be FY07 in this case. A
completed date of 8/15/2007 would be FY08. Appreciate any help.