Hi Everyone,
I have a following table
<tbody>
</tbody>
i want to populate Column No. "Quarter" with formula which will return the value as Quarter 1/Quarter 2/Quarter 3/Quarter 4 with suffix of budget year depend on the combination values of column no. "Activity Start Date" & "Activity End Date" fields.
For example,
if "Activity Start date" & "Activity End Date field contain dates between 1st Jan 2017 to 31st March 2017 then column no."Quarter" will return the value as "Quarter 1-2017"
similarly, if "Activity Start date" & "Activity End Date field contain dates between 1st April 2017 to 31st June 2017 then column no."Quarter" will return the value as "Quarter 2-2017"
Thank you so much in advance.
Regards
Shib
I have a following table
Quarter | Activity Start Date | Activity End Date | Budget Year |
Q2-2017 | 5th May 2017 | 26th June 2017 | 2017 |
<tbody>
</tbody>
i want to populate Column No. "Quarter" with formula which will return the value as Quarter 1/Quarter 2/Quarter 3/Quarter 4 with suffix of budget year depend on the combination values of column no. "Activity Start Date" & "Activity End Date" fields.
For example,
if "Activity Start date" & "Activity End Date field contain dates between 1st Jan 2017 to 31st March 2017 then column no."Quarter" will return the value as "Quarter 1-2017"
similarly, if "Activity Start date" & "Activity End Date field contain dates between 1st April 2017 to 31st June 2017 then column no."Quarter" will return the value as "Quarter 2-2017"
Thank you so much in advance.
Regards
Shib
Last edited: