Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I round a date?
I'm trying to round a date to the first day of the next (14 day) pay cycle to
show when vacation time is accrued. Right now, I have: - In cell B6 I manually enter the Date of Hire - To show when benefits start, 6 months after the date of hire (or 3 months if hired before 10/1/2005), in cell D6 =IF(B610/1/2005,EDATE(B6,3),EDATE(B6,6)) - To show when vacation is first accrued, 12 months after the benefit date, in cell A10 =EDATE(D6,12) I would really appreciate any help! Thanks! Cyndy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round Date & Time | Excel Discussion (Misc queries) | |||
Date Round Up | Excel Discussion (Misc queries) | |||
calcutale 2 date with round date | Excel Worksheet Functions | |||
Date round-up | Excel Discussion (Misc queries) | |||
Round date to first of month | Excel Discussion (Misc queries) |