Example 123.xlsx
Hi Guys Please help me with this calculation. I have attached a basic spreadsheet to support the description
Start Date End Date
Current Year: 2013/09/01 2014/08/31
Next Year: 2014/09/01 2015/08/31
Quote Current Year Quote Next Year
R100.00 R200.00
G9 must check for date range B2 to C2 or
B3 to C3 to correspond with the date manually inserted into G8
1) I type in a certain date into G8 format dd mmmm yyyy (example 04 October 2014)
If this date example manually typed in by me falls within the next year date range
the value of F2 (in this case R200.00) must be inserted into G9.
2) If G8 date value falls within the current year date range it must insert the value of E2 (in this case R100.00) into G9
Your help will be greatly appreciated
Kind regards
Willie
Bookmarks