ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   counting days? (https://www.excelbanter.com/excel-discussion-misc-queries/102444-counting-days.html)

Richard

counting days?
 
counting daily accrual days at 0.0274 per day in cell A1 and cell A2 has the
date of hire. What would be the formula for counting the days in cell A3?
Thanks in advance

robert111

counting days?
 

=A1*(today()-A2)


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=567015


bpeltzer

counting days?
 
If it's .0274 days accrued per calenday day since date of hire, in A3 enter
the formula
= a1 * (today() - a2)

"Richard" wrote:

counting daily accrual days at 0.0274 per day in cell A1 and cell A2 has the
date of hire. What would be the formula for counting the days in cell A3?
Thanks in advance



All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com