Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating as per the number of days in a month
Hi,
In col D i have date of joning of an employee and based on the date of joining i would like to calculate the remaining days and the number of coupons to be given to that employee. The amount of coupons is fixed 450. so per day it comes to 14.51 The figure will changed depending on the days in a month. Now i want the answer in the next column by using a formula which i am not able workout. Any help please -- Thanks Suleman Peerzade |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating as per the number of days in a month
Set two date value, one is for today, the other one is the end of year date.
And then use the end of year date minus today's date. You'll get the days. Date 1/1/2008 6/1/2007 Formula Description (Result) =A2-TODAY() Number of days from current date to end of 2007 (Varies) =A2-A3 Number of days from 6/1/2007 until the end of 2007 (214) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating as per the number of days in a month
Thanks liang,
I have sorted this issue was a bit lazy to complete it -- Thanks Suleman Peerzade "Liang" wrote: Set two date value, one is for today, the other one is the end of year date. And then use the end of year date minus today's date. You'll get the days. Date 1/1/2008 6/1/2007 Formula Description (Result) =A2-TODAY() Number of days from current date to end of 2007 (Varies) =A2-A3 Number of days from 6/1/2007 until the end of 2007 (214) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating how many days past in a month from today | Excel Discussion (Misc queries) | |||
Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
Days per month for calculating storage days | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating days in a month | Excel Discussion (Misc queries) |