Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate date on Semi-Monthly Basis
I am using Excel 2003 and trying to determine a formula to generate the next
date on a semi monthly basis. For example, I have a cell for next pay date, which when filled in I want the other cells to automatically generate the next pay date accurately. If I enter 4/15/2008 as my next paydate, then I want the other cells to readout 4/30/2008, 5/15/2008, 5/31/2008, etc. Any help would be greatly appreciated. Thanks! |
#2
|
|||
|
|||
Answer: Generate date on Semi-Monthly Basis
Sure, I can help you with that. Here's a step-by-step guide on how to generate dates on a semi-monthly basis in Excel 2003:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate date on Semi-Monthly Basis
How do you define your pay days? Are they always the 15th and the last day
of the month? If so, try =IF(DAY(A1)=15,DATE(YEAR(A1),MONTH(A1)+1,0),DATE(Y EAR(A1),MONTH(A1)+1,15)) -- David Biddulph "debinnyc" wrote in message ... I am using Excel 2003 and trying to determine a formula to generate the next date on a semi monthly basis. For example, I have a cell for next pay date, which when filled in I want the other cells to automatically generate the next pay date accurately. If I enter 4/15/2008 as my next paydate, then I want the other cells to readout 4/30/2008, 5/15/2008, 5/31/2008, etc. Any help would be greatly appreciated. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate date on Semi-Monthly Basis
Hi,
Put your start day in A1 and the in A2 and drag down =IF(DAY(A1)=15,EOMONTH(A1,0),DATE(YEAR(A1),MONTH(A 1)+1,15)) Mike "debinnyc" wrote: I am using Excel 2003 and trying to determine a formula to generate the next date on a semi monthly basis. For example, I have a cell for next pay date, which when filled in I want the other cells to automatically generate the next pay date accurately. If I enter 4/15/2008 as my next paydate, then I want the other cells to readout 4/30/2008, 5/15/2008, 5/31/2008, etc. Any help would be greatly appreciated. Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate date on Semi-Monthly Basis
Try:
a1 = 4/15/2008 a2 =date(year(a1),month(a1)+1,if(day(a1)=15,0,15)) Regards, Fred "debinnyc" wrote in message ... I am using Excel 2003 and trying to determine a formula to generate the next date on a semi monthly basis. For example, I have a cell for next pay date, which when filled in I want the other cells to automatically generate the next pay date accurately. If I enter 4/15/2008 as my next paydate, then I want the other cells to readout 4/30/2008, 5/15/2008, 5/31/2008, etc. Any help would be greatly appreciated. Thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate date on Semi-Monthly Basis
The ffollowing formula will do the trick:
=IF(DAY(G1)=15,DATE(YEAR(G1),MONTH(G1)+1,1)-1,DATE(YEAR(G1),MONTH(G1)+1,15)) -- Kevin Backmann "debinnyc" wrote: I am using Excel 2003 and trying to determine a formula to generate the next date on a semi monthly basis. For example, I have a cell for next pay date, which when filled in I want the other cells to automatically generate the next pay date accurately. If I enter 4/15/2008 as my next paydate, then I want the other cells to readout 4/30/2008, 5/15/2008, 5/31/2008, etc. Any help would be greatly appreciated. Thanks! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate date on Semi-Monthly Basis
I should have added if you get a name error then
Tools|Addins and check the analysis toolpack Mike "debinnyc" wrote: I am using Excel 2003 and trying to determine a formula to generate the next date on a semi monthly basis. For example, I have a cell for next pay date, which when filled in I want the other cells to automatically generate the next pay date accurately. If I enter 4/15/2008 as my next paydate, then I want the other cells to readout 4/30/2008, 5/15/2008, 5/31/2008, etc. Any help would be greatly appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort usage of rented rooms on monthly basis? | Charts and Charting in Excel | |||
Monthly Mortgage payments for a Semi annual compounding rate | Excel Worksheet Functions | |||
Date Axis Must be on Date Basis | Charts and Charting in Excel | |||
Comparing 2 years of data on a monthly basis | Charts and Charting in Excel | |||
Number of semi-monthly periods between 2 dates | Excel Worksheet Functions |