How to calculate quarterly
I have a worksheet which has a date between Januarys to December. This
worksheet I m using for record sales and Concession form. According to new rule sale against concession form should be submitted by concerned customer 1st quarter concession for should be deposited in next quarters 1st month. For example Date of Sales bill Expected Concession form submission 1.10.2005 1.01.2006 2.10.2005 5.10.2005 2.11.2005 4.11.2005 2.12.2005 3.12.2005 How it can be formulated and calculated. Thank and regards Rao Ratan Singh |
How to calculate quarterly
If your sale date is in A1, the concession date (first date of the next
quarter, per your example) can be calculated as =DATE(YEAR(A1),MONTH(A1)+3-MOD(MONTH(A1)-1,3),1) Is that what you're looking for? --Bruce "Rao Ratan Singh" wrote: I have a worksheet which has a date between Januarys to December. This worksheet I m using for record sales and Concession form. According to new rule sale against concession form should be submitted by concerned customer 1st quarter concession for should be deposited in next quarters 1st month. For example Date of Sales bill Expected Concession form submission 1.10.2005 1.01.2006 2.10.2005 5.10.2005 2.11.2005 4.11.2005 2.12.2005 3.12.2005 How it can be formulated and calculated. Thank and regards Rao Ratan Singh |
How to calculate quarterly
Thank you bpeltzer sir/mam
it is working. Thanks lot once again Rao Ratan Singh from india "bpeltzer" wrote: If your sale date is in A1, the concession date (first date of the next quarter, per your example) can be calculated as =DATE(YEAR(A1),MONTH(A1)+3-MOD(MONTH(A1)-1,3),1) Is that what you're looking for? --Bruce "Rao Ratan Singh" wrote: I have a worksheet which has a date between Januarys to December. This worksheet I m using for record sales and Concession form. According to new rule sale against concession form should be submitted by concerned customer 1st quarter concession for should be deposited in next quarters 1st month. For example Date of Sales bill Expected Concession form submission 1.10.2005 1.01.2006 2.10.2005 5.10.2005 2.11.2005 4.11.2005 2.12.2005 3.12.2005 How it can be formulated and calculated. Thank and regards Rao Ratan Singh |
All times are GMT +1. The time now is 12:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com